Dataset statistics
| Number of variables | 28 |
|---|---|
| Number of observations | 115609 |
| Missing cells | 0 |
| Missing cells (%) | 0.0% |
| Duplicate rows | 269 |
| Duplicate rows (%) | 0.2% |
| Total size in memory | 24.7 MiB |
| Average record size in memory | 224.0 B |
Variable types
| Text | 9 |
|---|---|
| Categorical | 4 |
| Numeric | 14 |
| DateTime | 1 |
| Dataset has 269 (0.2%) duplicate rows | Duplicates |
payment_value is highly overall correlated with price | High correlation |
customer_zip_code_prefix is highly overall correlated with customer_state | High correlation |
price is highly overall correlated with payment_value and 1 other fields | High correlation |
product_weight_g is highly overall correlated with price and 3 other fields | High correlation |
product_length_cm is highly overall correlated with product_weight_g and 1 other fields | High correlation |
product_height_cm is highly overall correlated with product_weight_g | High correlation |
product_width_cm is highly overall correlated with product_weight_g and 1 other fields | High correlation |
customer_state is highly overall correlated with customer_zip_code_prefix | High correlation |
order_status is highly imbalanced (93.4%) | Imbalance |
Reproduction
| Analysis started | 2024-04-25 02:24:35.804559 |
|---|---|
| Analysis finished | 2024-04-25 02:24:53.716036 |
| Duration | 17.91 seconds |
| Software version | ydata-profiling vv4.6.1 |
| Download configuration | config.json |
order_id
Text
| Distinct | 96516 |
|---|---|
| Distinct (%) | 83.5% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 903.3 KiB |
Length
| Max length | 32 |
|---|---|
| Median length | 32 |
| Mean length | 32 |
| Min length | 32 |
Characters and Unicode
| Total characters | 3699488 |
|---|---|
| Distinct characters | 16 |
| Distinct categories | 2 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 83927 ? |
|---|---|
| Unique (%) | 72.6% |
Sample
| 1st row | e481f51cbdc54678b7cc49136f2d6af7 |
|---|---|
| 2nd row | e481f51cbdc54678b7cc49136f2d6af7 |
| 3rd row | e481f51cbdc54678b7cc49136f2d6af7 |
| 4th row | 128e10d95713541c87cd1a2e48201934 |
| 5th row | 0e7e841ddf8f8f2de2bad69267ecfbcf |
| Value | Count | Frequency (%) |
| 895ab968e7bb0d5659d16cd74cd1650c | 63 | 0.1% |
| fedcd9f7ccdc8cba3a18defedd1a5547 | 38 | < 0.1% |
| fa65dad1b0e818e3ccc5cb0e39231352 | 29 | < 0.1% |
| ccf804e764ed5650cd8759557269dc13 | 26 | < 0.1% |
| 68986e4324f6a21481df4e6e89abcf01 | 24 | < 0.1% |
| c6492b842ac190db807c15aff21a7dd6 | 24 | < 0.1% |
| 465c2e1bee4561cb39e0db8c5993aafc | 24 | < 0.1% |
| a3725dfe487d359b5be08cac48b64ec5 | 24 | < 0.1% |
| 6d58638e32674bebee793a47ac4cbadc | 24 | < 0.1% |
| 285c2e15bebd4ac83635ccc563dc71f4 | 22 | < 0.1% |
| Other values (96506) | 115311 |
Most occurring characters
| Value | Count | Frequency (%) |
| 4 | 232347 | 6.3% |
| b | 232260 | 6.3% |
| 6 | 232183 | 6.3% |
| e | 231974 | 6.3% |
| c | 231513 | 6.3% |
| 3 | 231489 | 6.3% |
| 1 | 231448 | 6.3% |
| 7 | 231435 | 6.3% |
| 8 | 231366 | 6.3% |
| a | 231122 | 6.2% |
| Other values (6) | 1382351 |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 2311582 | |
| Lowercase Letter | 1387906 |
Most frequent character per category
Decimal Number
| Value | Count | Frequency (%) |
| 4 | 232347 | |
| 6 | 232183 | |
| 3 | 231489 | |
| 1 | 231448 | |
| 7 | 231435 | |
| 8 | 231366 | |
| 2 | 230768 | |
| 9 | 230559 | |
| 0 | 230074 | |
| 5 | 229913 |
Lowercase Letter
| Value | Count | Frequency (%) |
| b | 232260 | |
| e | 231974 | |
| c | 231513 | |
| a | 231122 | |
| f | 230865 | |
| d | 230172 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 2311582 | |
| Latin | 1387906 |
Most frequent character per script
Common
| Value | Count | Frequency (%) |
| 4 | 232347 | |
| 6 | 232183 | |
| 3 | 231489 | |
| 1 | 231448 | |
| 7 | 231435 | |
| 8 | 231366 | |
| 2 | 230768 | |
| 9 | 230559 | |
| 0 | 230074 | |
| 5 | 229913 |
Latin
| Value | Count | Frequency (%) |
| b | 232260 | |
| e | 231974 | |
| c | 231513 | |
| a | 231122 | |
| f | 230865 | |
| d | 230172 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 3699488 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 4 | 232347 | 6.3% |
| b | 232260 | 6.3% |
| 6 | 232183 | 6.3% |
| e | 231974 | 6.3% |
| c | 231513 | 6.3% |
| 3 | 231489 | 6.3% |
| 1 | 231448 | 6.3% |
| 7 | 231435 | 6.3% |
| 8 | 231366 | 6.3% |
| a | 231122 | 6.2% |
| Other values (6) | 1382351 |
customer_id
Text
| Distinct | 96516 |
|---|---|
| Distinct (%) | 83.5% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 903.3 KiB |
Length
| Max length | 32 |
|---|---|
| Median length | 32 |
| Mean length | 32 |
| Min length | 32 |
Characters and Unicode
| Total characters | 3699488 |
|---|---|
| Distinct characters | 16 |
| Distinct categories | 2 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 83927 ? |
|---|---|
| Unique (%) | 72.6% |
Sample
| 1st row | 9ef432eb6251297304e76186b10a928d |
|---|---|
| 2nd row | 9ef432eb6251297304e76186b10a928d |
| 3rd row | 9ef432eb6251297304e76186b10a928d |
| 4th row | a20e8105f23924cd00833fd87daa0831 |
| 5th row | 26c7ac168e1433912a51b924fbd34d34 |
| Value | Count | Frequency (%) |
| 270c23a11d024a44c896d1894b261a83 | 63 | 0.1% |
| 13aa59158da63ba0e93ec6ac2c07aacb | 38 | < 0.1% |
| 9af2372a1e49340278e7c1ef8d749f34 | 29 | < 0.1% |
| 92cd3ec6e2d643d4ebd0e3d6238f69e2 | 26 | < 0.1% |
| 86cc80fef09f7f39df4b0dbce48e81cb | 24 | < 0.1% |
| 6ee2f17e3b6c33d6a9557f280edd2925 | 24 | < 0.1% |
| 63b964e79dee32a3587651701a2b8dbf | 24 | < 0.1% |
| d22f25a9fadfb1abbc2e29395b1239f4 | 24 | < 0.1% |
| 2ba91e12e5e4c9f56b82b86d9031d329 | 24 | < 0.1% |
| b246eeed30b362c09d867b9e598bee51 | 22 | < 0.1% |
| Other values (96506) | 115311 |
Most occurring characters
| Value | Count | Frequency (%) |
| 2 | 231848 | 6.3% |
| f | 231815 | 6.3% |
| 5 | 231684 | 6.3% |
| c | 231607 | 6.3% |
| 6 | 231574 | 6.3% |
| 1 | 231546 | 6.3% |
| e | 231206 | 6.2% |
| 8 | 231191 | 6.2% |
| a | 231174 | 6.2% |
| d | 231155 | 6.2% |
| Other values (6) | 1384688 |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 2311390 | |
| Lowercase Letter | 1388098 |
Most frequent character per category
Decimal Number
| Value | Count | Frequency (%) |
| 2 | 231848 | |
| 5 | 231684 | |
| 6 | 231574 | |
| 1 | 231546 | |
| 8 | 231191 | |
| 9 | 231116 | |
| 3 | 231114 | |
| 7 | 231035 | |
| 4 | 230174 | |
| 0 | 230108 |
Lowercase Letter
| Value | Count | Frequency (%) |
| f | 231815 | |
| c | 231607 | |
| e | 231206 | |
| a | 231174 | |
| d | 231155 | |
| b | 231141 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 2311390 | |
| Latin | 1388098 |
Most frequent character per script
Common
| Value | Count | Frequency (%) |
| 2 | 231848 | |
| 5 | 231684 | |
| 6 | 231574 | |
| 1 | 231546 | |
| 8 | 231191 | |
| 9 | 231116 | |
| 3 | 231114 | |
| 7 | 231035 | |
| 4 | 230174 | |
| 0 | 230108 |
Latin
| Value | Count | Frequency (%) |
| f | 231815 | |
| c | 231607 | |
| e | 231206 | |
| a | 231174 | |
| d | 231155 | |
| b | 231141 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 3699488 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 2 | 231848 | 6.3% |
| f | 231815 | 6.3% |
| 5 | 231684 | 6.3% |
| c | 231607 | 6.3% |
| 6 | 231574 | 6.3% |
| 1 | 231546 | 6.3% |
| e | 231206 | 6.2% |
| 8 | 231191 | 6.2% |
| a | 231174 | 6.2% |
| d | 231155 | 6.2% |
| Other values (6) | 1384688 |
order_status
Categorical
IMBALANCE 
| Distinct | 7 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 903.3 KiB |
| delivered | |
|---|---|
| shipped | 1138 |
| canceled | 536 |
| invoiced | 358 |
| processing | 357 |
| Other values (2) | 10 |
Length
| Max length | 11 |
|---|---|
| Median length | 9 |
| Mean length | 8.9757631 |
| Min length | 7 |
Characters and Unicode
| Total characters | 1037679 |
|---|---|
| Distinct characters | 16 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | delivered |
|---|---|
| 2nd row | delivered |
| 3rd row | delivered |
| 4th row | delivered |
| 5th row | delivered |
Common Values
| Value | Count | Frequency (%) |
| delivered | 113210 | |
| shipped | 1138 | 1.0% |
| canceled | 536 | 0.5% |
| invoiced | 358 | 0.3% |
| processing | 357 | 0.3% |
| unavailable | 7 | < 0.1% |
| approved | 3 | < 0.1% |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| delivered | 113210 | |
| shipped | 1138 | 1.0% |
| canceled | 536 | 0.5% |
| invoiced | 358 | 0.3% |
| processing | 357 | 0.3% |
| unavailable | 7 | < 0.1% |
| approved | 3 | < 0.1% |
Most occurring characters
| Value | Count | Frequency (%) |
| e | 342565 | |
| d | 228455 | |
| i | 115428 | 11.1% |
| l | 113760 | 11.0% |
| v | 113578 | 10.9% |
| r | 113570 | 10.9% |
| p | 2639 | 0.3% |
| s | 1852 | 0.2% |
| c | 1787 | 0.2% |
| n | 1258 | 0.1% |
| Other values (6) | 2787 | 0.3% |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 1037679 |
Most frequent character per category
Lowercase Letter
| Value | Count | Frequency (%) |
| e | 342565 | |
| d | 228455 | |
| i | 115428 | 11.1% |
| l | 113760 | 11.0% |
| v | 113578 | 10.9% |
| r | 113570 | 10.9% |
| p | 2639 | 0.3% |
| s | 1852 | 0.2% |
| c | 1787 | 0.2% |
| n | 1258 | 0.1% |
| Other values (6) | 2787 | 0.3% |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 1037679 |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| e | 342565 | |
| d | 228455 | |
| i | 115428 | 11.1% |
| l | 113760 | 11.0% |
| v | 113578 | 10.9% |
| r | 113570 | 10.9% |
| p | 2639 | 0.3% |
| s | 1852 | 0.2% |
| c | 1787 | 0.2% |
| n | 1258 | 0.1% |
| Other values (6) | 2787 | 0.3% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 1037679 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| e | 342565 | |
| d | 228455 | |
| i | 115428 | 11.1% |
| l | 113760 | 11.0% |
| v | 113578 | 10.9% |
| r | 113570 | 10.9% |
| p | 2639 | 0.3% |
| s | 1852 | 0.2% |
| c | 1787 | 0.2% |
| n | 1258 | 0.1% |
| Other values (6) | 2787 | 0.3% |
payment_sequential
Real number (ℝ)
| Distinct | 29 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 1.093747 |
| Minimum | 1 |
|---|---|
| Maximum | 29 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 903.3 KiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 1 |
| Q1 | 1 |
| median | 1 |
| Q3 | 1 |
| 95-th percentile | 1 |
| Maximum | 29 |
| Range | 28 |
| Interquartile range (IQR) | 0 |
Descriptive statistics
| Standard deviation | 0.72984871 |
|---|---|
| Coefficient of variation (CV) | 0.66729206 |
| Kurtosis | 350.44021 |
| Mean | 1.093747 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 16.001768 |
| Sum | 126447 |
| Variance | 0.53267914 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 1 | 110662 | |
| 2 | 3298 | 2.9% |
| 3 | 636 | 0.6% |
| 4 | 307 | 0.3% |
| 5 | 183 | 0.2% |
| 6 | 127 | 0.1% |
| 7 | 88 | 0.1% |
| 8 | 58 | 0.1% |
| 9 | 47 | < 0.1% |
| 10 | 40 | < 0.1% |
| Other values (19) | 163 | 0.1% |
| Value | Count | Frequency (%) |
| 1 | 110662 | |
| 2 | 3298 | 2.9% |
| 3 | 636 | 0.6% |
| 4 | 307 | 0.3% |
| 5 | 183 | 0.2% |
| 6 | 127 | 0.1% |
| 7 | 88 | 0.1% |
| 8 | 58 | 0.1% |
| 9 | 47 | < 0.1% |
| 10 | 40 | < 0.1% |
| Value | Count | Frequency (%) |
| 29 | 1 | < 0.1% |
| 28 | 1 | < 0.1% |
| 27 | 1 | < 0.1% |
| 26 | 2 | < 0.1% |
| 25 | 2 | < 0.1% |
| 24 | 2 | < 0.1% |
| 23 | 2 | < 0.1% |
| 22 | 3 | |
| 21 | 6 | |
| 20 | 6 |
payment_type
Categorical
| Distinct | 4 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 903.3 KiB |
| credit_card | |
|---|---|
| boleto | |
| voucher | 6162 |
| debit_card | 1659 |
Length
| Max length | 11 |
|---|---|
| Median length | 11 |
| Mean length | 9.7989084 |
| Min length | 6 |
Characters and Unicode
| Total characters | 1132842 |
|---|---|
| Distinct characters | 14 |
| Distinct categories | 2 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | credit_card |
|---|---|
| 2nd row | voucher |
| 3rd row | voucher |
| 4th row | credit_card |
| 5th row | credit_card |
Common Values
| Value | Count | Frequency (%) |
| credit_card | 85278 | |
| boleto | 22510 | 19.5% |
| voucher | 6162 | 5.3% |
| debit_card | 1659 | 1.4% |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| credit_card | 85278 | |
| boleto | 22510 | 19.5% |
| voucher | 6162 | 5.3% |
| debit_card | 1659 | 1.4% |
Most occurring characters
| Value | Count | Frequency (%) |
| c | 178377 | |
| r | 178377 | |
| d | 173874 | |
| e | 115609 | |
| t | 109447 | |
| i | 86937 | |
| _ | 86937 | |
| a | 86937 | |
| o | 51182 | 4.5% |
| b | 24169 | 2.1% |
| Other values (4) | 40996 | 3.6% |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 1045905 | |
| Connector Punctuation | 86937 | 7.7% |
Most frequent character per category
Lowercase Letter
| Value | Count | Frequency (%) |
| c | 178377 | |
| r | 178377 | |
| d | 173874 | |
| e | 115609 | |
| t | 109447 | |
| i | 86937 | |
| a | 86937 | |
| o | 51182 | 4.9% |
| b | 24169 | 2.3% |
| l | 22510 | 2.2% |
| Other values (3) | 18486 | 1.8% |
Connector Punctuation
| Value | Count | Frequency (%) |
| _ | 86937 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 1045905 | |
| Common | 86937 | 7.7% |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| c | 178377 | |
| r | 178377 | |
| d | 173874 | |
| e | 115609 | |
| t | 109447 | |
| i | 86937 | |
| a | 86937 | |
| o | 51182 | 4.9% |
| b | 24169 | 2.3% |
| l | 22510 | 2.2% |
| Other values (3) | 18486 | 1.8% |
Common
| Value | Count | Frequency (%) |
| _ | 86937 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 1132842 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| c | 178377 | |
| r | 178377 | |
| d | 173874 | |
| e | 115609 | |
| t | 109447 | |
| i | 86937 | |
| _ | 86937 | |
| a | 86937 | |
| o | 51182 | 4.5% |
| b | 24169 | 2.1% |
| Other values (4) | 40996 | 3.6% |
payment_installments
Real number (ℝ)
| Distinct | 24 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 2.9462326 |
| Minimum | 0 |
|---|---|
| Maximum | 24 |
| Zeros | 3 |
| Zeros (%) | < 0.1% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 903.3 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 1 |
| Q1 | 1 |
| median | 2 |
| Q3 | 4 |
| 95-th percentile | 10 |
| Maximum | 24 |
| Range | 24 |
| Interquartile range (IQR) | 3 |
Descriptive statistics
| Standard deviation | 2.7810871 |
|---|---|
| Coefficient of variation (CV) | 0.94394691 |
| Kurtosis | 2.5137681 |
| Mean | 2.9462326 |
| Median Absolute Deviation (MAD) | 1 |
| Skewness | 1.6181717 |
| Sum | 340611 |
| Variance | 7.7344456 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 1 | 57599 | |
| 2 | 13404 | 11.6% |
| 3 | 11551 | 10.0% |
| 4 | 7855 | 6.8% |
| 10 | 6785 | 5.9% |
| 5 | 5928 | 5.1% |
| 8 | 5013 | 4.3% |
| 6 | 4546 | 3.9% |
| 7 | 1789 | 1.5% |
| 9 | 710 | 0.6% |
| Other values (14) | 429 | 0.4% |
| Value | Count | Frequency (%) |
| 0 | 3 | < 0.1% |
| 1 | 57599 | |
| 2 | 13404 | 11.6% |
| 3 | 11551 | 10.0% |
| 4 | 7855 | 6.8% |
| 5 | 5928 | 5.1% |
| 6 | 4546 | 3.9% |
| 7 | 1789 | 1.5% |
| 8 | 5013 | 4.3% |
| 9 | 710 | 0.6% |
| Value | Count | Frequency (%) |
| 24 | 34 | < 0.1% |
| 23 | 1 | < 0.1% |
| 22 | 1 | < 0.1% |
| 21 | 6 | < 0.1% |
| 20 | 20 | < 0.1% |
| 18 | 38 | |
| 17 | 7 | < 0.1% |
| 16 | 7 | < 0.1% |
| 15 | 91 | |
| 14 | 16 | < 0.1% |
payment_value
Real number (ℝ)
HIGH CORRELATION 
| Distinct | 28657 |
|---|---|
| Distinct (%) | 24.8% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 172.38738 |
| Minimum | 0 |
|---|---|
| Maximum | 13664.08 |
| Zeros | 6 |
| Zeros (%) | < 0.1% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 903.3 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 27.23 |
| Q1 | 60.87 |
| median | 108.05 |
| Q3 | 189.48 |
| 95-th percentile | 514.98 |
| Maximum | 13664.08 |
| Range | 13664.08 |
| Interquartile range (IQR) | 128.61 |
Descriptive statistics
| Standard deviation | 265.87397 |
|---|---|
| Coefficient of variation (CV) | 1.5423053 |
| Kurtosis | 524.94523 |
| Mean | 172.38738 |
| Median Absolute Deviation (MAD) | 56.67 |
| Skewness | 14.306544 |
| Sum | 19929533 |
| Variance | 70688.967 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 50 | 338 | 0.3% |
| 100 | 285 | 0.2% |
| 20 | 283 | 0.2% |
| 77.57 | 249 | 0.2% |
| 35 | 163 | 0.1% |
| 73.34 | 157 | 0.1% |
| 30 | 134 | 0.1% |
| 116.94 | 130 | 0.1% |
| 56.78 | 120 | 0.1% |
| 155.14 | 119 | 0.1% |
| Other values (28647) | 113631 |
| Value | Count | Frequency (%) |
| 0 | 6 | |
| 0.01 | 6 | |
| 0.03 | 2 | < 0.1% |
| 0.05 | 2 | < 0.1% |
| 0.08 | 2 | < 0.1% |
| 0.09 | 1 | < 0.1% |
| 0.1 | 3 | |
| 0.11 | 2 | < 0.1% |
| 0.13 | 1 | < 0.1% |
| 0.14 | 4 |
| Value | Count | Frequency (%) |
| 13664.08 | 8 | |
| 7274.88 | 4 | |
| 6929.31 | 1 | < 0.1% |
| 6726.66 | 1 | < 0.1% |
| 6081.54 | 6 | |
| 4950.34 | 1 | < 0.1% |
| 4809.44 | 2 | < 0.1% |
| 4764.34 | 1 | < 0.1% |
| 4681.78 | 1 | < 0.1% |
| 4513.32 | 1 | < 0.1% |
| Distinct | 93396 |
|---|---|
| Distinct (%) | 80.8% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 903.3 KiB |
Length
| Max length | 32 |
|---|---|
| Median length | 32 |
| Mean length | 32 |
| Min length | 32 |
Characters and Unicode
| Total characters | 3699488 |
|---|---|
| Distinct characters | 16 |
| Distinct categories | 2 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 79377 ? |
|---|---|
| Unique (%) | 68.7% |
Sample
| 1st row | 7c396fd4830fd04220f754e42b4e5bff |
|---|---|
| 2nd row | 7c396fd4830fd04220f754e42b4e5bff |
| 3rd row | 7c396fd4830fd04220f754e42b4e5bff |
| 4th row | 3a51803cc0d012c3b5dc8b7528cb05f7 |
| 5th row | ef0996a1a279c26e7ecbd737be23d235 |
| Value | Count | Frequency (%) |
| 9a736b248f67d166d2fbb006bcb877c3 | 75 | 0.1% |
| 6fbc7cdadbb522125f4b27ae9dee4060 | 38 | < 0.1% |
| f9ae226291893fda10af7965268fb7f6 | 35 | < 0.1% |
| 8af7ac63b2efbcbd88e5b11505e8098a | 29 | < 0.1% |
| 569aa12b73b5f7edeaa6f2a01603e381 | 26 | < 0.1% |
| db1af3fd6b23ac3873ef02619d548f9c | 24 | < 0.1% |
| 90807fdb59eec2152bc977feeb6e47e7 | 24 | < 0.1% |
| d97b3cfb22b0d6b25ac9ed4e9c2d481b | 24 | < 0.1% |
| 1d2435aa3b858d45c707c9fc25e18779 | 24 | < 0.1% |
| 5419a7c9b86a43d8140e2939cd2c2f7e | 24 | < 0.1% |
| Other values (93386) | 115286 |
Most occurring characters
| Value | Count | Frequency (%) |
| 6 | 232253 | 6.3% |
| b | 231885 | 6.3% |
| 1 | 231813 | 6.3% |
| a | 231488 | 6.3% |
| d | 231353 | 6.3% |
| 3 | 231341 | 6.3% |
| e | 231271 | 6.3% |
| 8 | 231179 | 6.2% |
| 2 | 231112 | 6.2% |
| 5 | 231087 | 6.2% |
| Other values (6) | 1384706 |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 2312012 | |
| Lowercase Letter | 1387476 |
Most frequent character per category
Decimal Number
| Value | Count | Frequency (%) |
| 6 | 232253 | |
| 1 | 231813 | |
| 3 | 231341 | |
| 8 | 231179 | |
| 2 | 231112 | |
| 5 | 231087 | |
| 9 | 231084 | |
| 7 | 231012 | |
| 0 | 230821 | |
| 4 | 230310 |
Lowercase Letter
| Value | Count | Frequency (%) |
| b | 231885 | |
| a | 231488 | |
| d | 231353 | |
| e | 231271 | |
| f | 230923 | |
| c | 230556 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 2312012 | |
| Latin | 1387476 |
Most frequent character per script
Common
| Value | Count | Frequency (%) |
| 6 | 232253 | |
| 1 | 231813 | |
| 3 | 231341 | |
| 8 | 231179 | |
| 2 | 231112 | |
| 5 | 231087 | |
| 9 | 231084 | |
| 7 | 231012 | |
| 0 | 230821 | |
| 4 | 230310 |
Latin
| Value | Count | Frequency (%) |
| b | 231885 | |
| a | 231488 | |
| d | 231353 | |
| e | 231271 | |
| f | 230923 | |
| c | 230556 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 3699488 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 6 | 232253 | 6.3% |
| b | 231885 | 6.3% |
| 1 | 231813 | 6.3% |
| a | 231488 | 6.3% |
| d | 231353 | 6.3% |
| 3 | 231341 | 6.3% |
| e | 231271 | 6.3% |
| 8 | 231179 | 6.2% |
| 2 | 231112 | 6.2% |
| 5 | 231087 | 6.2% |
| Other values (6) | 1384706 |
customer_zip_code_prefix
Real number (ℝ)
HIGH CORRELATION 
| Distinct | 14907 |
|---|---|
| Distinct (%) | 12.9% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 35061.538 |
| Minimum | 1003 |
|---|---|
| Maximum | 99980 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 903.3 KiB |
Quantile statistics
| Minimum | 1003 |
|---|---|
| 5-th percentile | 3286 |
| Q1 | 11310 |
| median | 24241 |
| Q3 | 58745 |
| 95-th percentile | 90620 |
| Maximum | 99980 |
| Range | 98977 |
| Interquartile range (IQR) | 47435 |
Descriptive statistics
| Standard deviation | 29841.672 |
|---|---|
| Coefficient of variation (CV) | 0.85112273 |
| Kurtosis | -0.78410177 |
| Mean | 35061.538 |
| Median Absolute Deviation (MAD) | 16231 |
| Skewness | 0.78436422 |
| Sum | 4.0534293 × 109 |
| Variance | 8.9052537 × 108 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 24220 | 154 | 0.1% |
| 22793 | 151 | 0.1% |
| 22790 | 150 | 0.1% |
| 24230 | 138 | 0.1% |
| 22775 | 126 | 0.1% |
| 35162 | 124 | 0.1% |
| 29101 | 112 | 0.1% |
| 11740 | 110 | 0.1% |
| 13087 | 107 | 0.1% |
| 36570 | 104 | 0.1% |
| Other values (14897) | 114333 |
| Value | Count | Frequency (%) |
| 1003 | 1 | < 0.1% |
| 1004 | 2 | < 0.1% |
| 1005 | 6 | |
| 1006 | 2 | < 0.1% |
| 1007 | 4 | |
| 1008 | 3 | < 0.1% |
| 1009 | 8 | |
| 1011 | 6 | |
| 1012 | 2 | < 0.1% |
| 1013 | 3 | < 0.1% |
| Value | Count | Frequency (%) |
| 99980 | 3 | < 0.1% |
| 99970 | 1 | < 0.1% |
| 99965 | 2 | < 0.1% |
| 99960 | 1 | < 0.1% |
| 99955 | 3 | < 0.1% |
| 99950 | 9 | |
| 99940 | 2 | < 0.1% |
| 99930 | 5 | |
| 99925 | 1 | < 0.1% |
| 99920 | 1 | < 0.1% |
customer_city
Text
| Distinct | 4093 |
|---|---|
| Distinct (%) | 3.5% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 903.3 KiB |
Length
| Max length | 32 |
|---|---|
| Median length | 27 |
| Mean length | 10.332855 |
| Min length | 3 |
Characters and Unicode
| Total characters | 1194571 |
|---|---|
| Distinct characters | 31 |
| Distinct categories | 5 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 1042 ? |
|---|---|
| Unique (%) | 0.9% |
Sample
| 1st row | sao paulo |
|---|---|
| 2nd row | sao paulo |
| 3rd row | sao paulo |
| 4th row | sao paulo |
| 5th row | sao paulo |
| Value | Count | Frequency (%) |
| sao | 24620 | 12.1% |
| paulo | 18348 | 9.1% |
| de | 11267 | 5.6% |
| rio | 9627 | 4.8% |
| janeiro | 8022 | 4.0% |
| do | 4964 | 2.4% |
| belo | 3269 | 1.6% |
| horizonte | 3224 | 1.6% |
| brasilia | 2444 | 1.2% |
| porto | 1942 | 1.0% |
| Other values (3268) | 114916 |
Most occurring characters
| Value | Count | Frequency (%) |
| a | 197038 | |
| o | 147371 | |
| i | 91350 | 7.6% |
| r | 88530 | 7.4% |
| 87034 | 7.3% | |
| e | 77539 | 6.5% |
| s | 73205 | 6.1% |
| n | 52923 | 4.4% |
| u | 52440 | 4.4% |
| l | 52072 | 4.4% |
| Other values (21) | 275069 |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 1106996 | |
| Space Separator | 87034 | 7.3% |
| Dash Punctuation | 281 | < 0.1% |
| Other Punctuation | 258 | < 0.1% |
| Decimal Number | 2 | < 0.1% |
Most frequent character per category
Lowercase Letter
| Value | Count | Frequency (%) |
| a | 197038 | |
| o | 147371 | |
| i | 91350 | 8.3% |
| r | 88530 | 8.0% |
| e | 77539 | 7.0% |
| s | 73205 | 6.6% |
| n | 52923 | 4.8% |
| u | 52440 | 4.7% |
| l | 52072 | 4.7% |
| p | 43443 | 3.9% |
| Other values (16) | 231085 |
Decimal Number
| Value | Count | Frequency (%) |
| 1 | 1 | |
| 4 | 1 |
Space Separator
| Value | Count | Frequency (%) |
| 87034 |
Dash Punctuation
| Value | Count | Frequency (%) |
| - | 281 |
Other Punctuation
| Value | Count | Frequency (%) |
| ' | 258 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 1106996 | |
| Common | 87575 | 7.3% |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| a | 197038 | |
| o | 147371 | |
| i | 91350 | 8.3% |
| r | 88530 | 8.0% |
| e | 77539 | 7.0% |
| s | 73205 | 6.6% |
| n | 52923 | 4.8% |
| u | 52440 | 4.7% |
| l | 52072 | 4.7% |
| p | 43443 | 3.9% |
| Other values (16) | 231085 |
Common
| Value | Count | Frequency (%) |
| 87034 | ||
| - | 281 | 0.3% |
| ' | 258 | 0.3% |
| 1 | 1 | < 0.1% |
| 4 | 1 | < 0.1% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 1194571 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| a | 197038 | |
| o | 147371 | |
| i | 91350 | 7.6% |
| r | 88530 | 7.4% |
| 87034 | 7.3% | |
| e | 77539 | 6.5% |
| s | 73205 | 6.1% |
| n | 52923 | 4.4% |
| u | 52440 | 4.4% |
| l | 52072 | 4.4% |
| Other values (21) | 275069 |
customer_state
Categorical
HIGH CORRELATION 
| Distinct | 27 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 903.3 KiB |
| SP | |
|---|---|
| RJ | |
| MG | |
| RS | |
| PR | |
| Other values (22) |
Length
| Max length | 2 |
|---|---|
| Median length | 2 |
| Mean length | 2 |
| Min length | 2 |
Characters and Unicode
| Total characters | 231218 |
|---|---|
| Distinct characters | 17 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | SP |
|---|---|
| 2nd row | SP |
| 3rd row | SP |
| 4th row | SP |
| 5th row | SP |
Common Values
| Value | Count | Frequency (%) |
| SP | 48797 | |
| RJ | 14987 | 13.0% |
| MG | 13429 | 11.6% |
| RS | 6413 | 5.5% |
| PR | 5879 | 5.1% |
| SC | 4218 | 3.6% |
| BA | 3942 | 3.4% |
| DF | 2449 | 2.1% |
| GO | 2359 | 2.0% |
| ES | 2300 | 2.0% |
| Other values (17) | 10836 | 9.4% |
Length
| Value | Count | Frequency (%) |
| sp | 48797 | |
| rj | 14987 | 13.0% |
| mg | 13429 | 11.6% |
| rs | 6413 | 5.5% |
| pr | 5879 | 5.1% |
| sc | 4218 | 3.6% |
| ba | 3942 | 3.4% |
| df | 2449 | 2.1% |
| go | 2359 | 2.0% |
| es | 2300 | 2.0% |
| Other values (17) | 10836 | 9.4% |
Most occurring characters
| Value | Count | Frequency (%) |
| S | 62966 | |
| P | 58871 | |
| R | 28218 | |
| M | 16380 | 7.1% |
| G | 15788 | 6.8% |
| J | 14987 | 6.5% |
| A | 6654 | 2.9% |
| E | 6071 | 2.6% |
| C | 5838 | 2.5% |
| B | 4561 | 2.0% |
| Other values (7) | 10884 | 4.7% |
Most occurring categories
| Value | Count | Frequency (%) |
| Uppercase Letter | 231218 |
Most frequent character per category
Uppercase Letter
| Value | Count | Frequency (%) |
| S | 62966 | |
| P | 58871 | |
| R | 28218 | |
| M | 16380 | 7.1% |
| G | 15788 | 6.8% |
| J | 14987 | 6.5% |
| A | 6654 | 2.9% |
| E | 6071 | 2.6% |
| C | 5838 | 2.5% |
| B | 4561 | 2.0% |
| Other values (7) | 10884 | 4.7% |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 231218 |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| S | 62966 | |
| P | 58871 | |
| R | 28218 | |
| M | 16380 | 7.1% |
| G | 15788 | 6.8% |
| J | 14987 | 6.5% |
| A | 6654 | 2.9% |
| E | 6071 | 2.6% |
| C | 5838 | 2.5% |
| B | 4561 | 2.0% |
| Other values (7) | 10884 | 4.7% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 231218 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| S | 62966 | |
| P | 58871 | |
| R | 28218 | |
| M | 16380 | 7.1% |
| G | 15788 | 6.8% |
| J | 14987 | 6.5% |
| A | 6654 | 2.9% |
| E | 6071 | 2.6% |
| C | 5838 | 2.5% |
| B | 4561 | 2.0% |
| Other values (7) | 10884 | 4.7% |
order_item_id
Real number (ℝ)
| Distinct | 21 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 1.194535 |
| Minimum | 1 |
|---|---|
| Maximum | 21 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 903.3 KiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 1 |
| Q1 | 1 |
| median | 1 |
| Q3 | 1 |
| 95-th percentile | 2 |
| Maximum | 21 |
| Range | 20 |
| Interquartile range (IQR) | 0 |
Descriptive statistics
| Standard deviation | 0.68592588 |
|---|---|
| Coefficient of variation (CV) | 0.57421998 |
| Kurtosis | 93.440808 |
| Mean | 1.194535 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 7.195206 |
| Sum | 138099 |
| Variance | 0.47049432 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 1 | 101340 | |
| 2 | 10055 | 8.7% |
| 3 | 2326 | 2.0% |
| 4 | 969 | 0.8% |
| 5 | 458 | 0.4% |
| 6 | 256 | 0.2% |
| 7 | 60 | 0.1% |
| 8 | 35 | < 0.1% |
| 9 | 28 | < 0.1% |
| 10 | 25 | < 0.1% |
| Other values (11) | 57 | < 0.1% |
| Value | Count | Frequency (%) |
| 1 | 101340 | |
| 2 | 10055 | 8.7% |
| 3 | 2326 | 2.0% |
| 4 | 969 | 0.8% |
| 5 | 458 | 0.4% |
| 6 | 256 | 0.2% |
| 7 | 60 | 0.1% |
| 8 | 35 | < 0.1% |
| 9 | 28 | < 0.1% |
| 10 | 25 | < 0.1% |
| Value | Count | Frequency (%) |
| 21 | 1 | < 0.1% |
| 20 | 2 | < 0.1% |
| 19 | 2 | < 0.1% |
| 18 | 2 | < 0.1% |
| 17 | 2 | < 0.1% |
| 16 | 2 | < 0.1% |
| 15 | 4 | < 0.1% |
| 14 | 6 | |
| 13 | 7 | |
| 12 | 12 |
product_id
Text
| Distinct | 32171 |
|---|---|
| Distinct (%) | 27.8% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 903.3 KiB |
Length
| Max length | 32 |
|---|---|
| Median length | 32 |
| Mean length | 32 |
| Min length | 32 |
Characters and Unicode
| Total characters | 3699488 |
|---|---|
| Distinct characters | 16 |
| Distinct categories | 2 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 16932 ? |
|---|---|
| Unique (%) | 14.6% |
Sample
| 1st row | 87285b34884572647811a353c7ac498a |
|---|---|
| 2nd row | 87285b34884572647811a353c7ac498a |
| 3rd row | 87285b34884572647811a353c7ac498a |
| 4th row | 87285b34884572647811a353c7ac498a |
| 5th row | 87285b34884572647811a353c7ac498a |
| Value | Count | Frequency (%) |
| aca2eb7d00ea1a7b8ebd4e68314663af | 533 | 0.5% |
| 99a4788cb24856965c36a24e339b6058 | 517 | 0.4% |
| 422879e10f46682990de24d770e7f83d | 507 | 0.4% |
| 389d119b48cf3043d311335e499d9c6b | 405 | 0.4% |
| 368c6c730842d78016ad823897a372db | 395 | 0.3% |
| 53759a2ecddad2bb87a079a1f1519f73 | 389 | 0.3% |
| d1c427060a0f73f6b889a5c7c61f2ac4 | 354 | 0.3% |
| 53b36df67ebb7c41585e8d54d6772e08 | 324 | 0.3% |
| 154e7e31ebfa092203795c972e5804a6 | 294 | 0.3% |
| 3dd2a17168ec895c781a9191c1e95ad7 | 276 | 0.2% |
| Other values (32161) | 111615 |
Most occurring characters
| Value | Count | Frequency (%) |
| 3 | 237911 | 6.4% |
| 9 | 235951 | 6.4% |
| e | 233656 | 6.3% |
| 7 | 233105 | 6.3% |
| 8 | 232719 | 6.3% |
| 4 | 231409 | 6.3% |
| a | 231308 | 6.3% |
| c | 231075 | 6.2% |
| 2 | 230954 | 6.2% |
| 6 | 230872 | 6.2% |
| Other values (6) | 1370528 |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 2321899 | |
| Lowercase Letter | 1377589 |
Most frequent character per category
Decimal Number
| Value | Count | Frequency (%) |
| 3 | 237911 | |
| 9 | 235951 | |
| 7 | 233105 | |
| 8 | 232719 | |
| 4 | 231409 | |
| 2 | 230954 | |
| 6 | 230872 | |
| 0 | 230822 | |
| 5 | 229692 | |
| 1 | 228464 |
Lowercase Letter
| Value | Count | Frequency (%) |
| e | 233656 | |
| a | 231308 | |
| c | 231075 | |
| b | 229587 | |
| d | 227350 | |
| f | 224613 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 2321899 | |
| Latin | 1377589 |
Most frequent character per script
Common
| Value | Count | Frequency (%) |
| 3 | 237911 | |
| 9 | 235951 | |
| 7 | 233105 | |
| 8 | 232719 | |
| 4 | 231409 | |
| 2 | 230954 | |
| 6 | 230872 | |
| 0 | 230822 | |
| 5 | 229692 | |
| 1 | 228464 |
Latin
| Value | Count | Frequency (%) |
| e | 233656 | |
| a | 231308 | |
| c | 231075 | |
| b | 229587 | |
| d | 227350 | |
| f | 224613 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 3699488 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 3 | 237911 | 6.4% |
| 9 | 235951 | 6.4% |
| e | 233656 | 6.3% |
| 7 | 233105 | 6.3% |
| 8 | 232719 | 6.3% |
| 4 | 231409 | 6.3% |
| a | 231308 | 6.3% |
| c | 231075 | 6.2% |
| 2 | 230954 | 6.2% |
| 6 | 230872 | 6.2% |
| Other values (6) | 1370528 |
seller_id
Text
| Distinct | 3028 |
|---|---|
| Distinct (%) | 2.6% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 903.3 KiB |
Length
| Max length | 32 |
|---|---|
| Median length | 32 |
| Mean length | 32 |
| Min length | 32 |
Characters and Unicode
| Total characters | 3699488 |
|---|---|
| Distinct characters | 16 |
| Distinct categories | 2 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 485 ? |
|---|---|
| Unique (%) | 0.4% |
Sample
| 1st row | 3504c0cb71d7fa48d967e0e4c94d59d9 |
|---|---|
| 2nd row | 3504c0cb71d7fa48d967e0e4c94d59d9 |
| 3rd row | 3504c0cb71d7fa48d967e0e4c94d59d9 |
| 4th row | 3504c0cb71d7fa48d967e0e4c94d59d9 |
| 5th row | 3504c0cb71d7fa48d967e0e4c94d59d9 |
| Value | Count | Frequency (%) |
| 4a3ca9315b744ce9f8e9374361493884 | 2128 | 1.8% |
| 6560211a19b47992c3666cc44a7e94c0 | 2111 | 1.8% |
| 1f50f920176fa81dab994f9023523100 | 2009 | 1.7% |
| cc419e0650a3c5ba77189a1882b7556a | 1885 | 1.6% |
| da8622b14eb17ae2831f4ac5b9dab84a | 1656 | 1.4% |
| 955fee9216a65b617aa5c0531780ce60 | 1517 | 1.3% |
| 1025f0e2d44d7041d6cf58b6550e0bfa | 1465 | 1.3% |
| 7c67e1448b00f6e969d365cea6b010ab | 1454 | 1.3% |
| 7a67c85e85bb2ce8582c35f2203ad736 | 1236 | 1.1% |
| ea8482cd71df3c1969d7b9473ff13abc | 1233 | 1.1% |
| Other values (3018) | 98915 |
Most occurring characters
| Value | Count | Frequency (%) |
| 1 | 251950 | 6.8% |
| c | 243876 | 6.6% |
| 4 | 243091 | 6.6% |
| 6 | 238193 | 6.4% |
| 0 | 237394 | 6.4% |
| a | 236721 | 6.4% |
| b | 235816 | 6.4% |
| 3 | 235558 | 6.4% |
| 9 | 228810 | 6.2% |
| 2 | 227464 | 6.1% |
| Other values (6) | 1320615 |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 2339688 | |
| Lowercase Letter | 1359800 |
Most frequent character per category
Decimal Number
| Value | Count | Frequency (%) |
| 1 | 251950 | |
| 4 | 243091 | |
| 6 | 238193 | |
| 0 | 237394 | |
| 3 | 235558 | |
| 9 | 228810 | |
| 2 | 227464 | |
| 8 | 226366 | |
| 5 | 225942 | |
| 7 | 224920 |
Lowercase Letter
| Value | Count | Frequency (%) |
| c | 243876 | |
| a | 236721 | |
| b | 235816 | |
| e | 216428 | |
| f | 214706 | |
| d | 212253 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 2339688 | |
| Latin | 1359800 |
Most frequent character per script
Common
| Value | Count | Frequency (%) |
| 1 | 251950 | |
| 4 | 243091 | |
| 6 | 238193 | |
| 0 | 237394 | |
| 3 | 235558 | |
| 9 | 228810 | |
| 2 | 227464 | |
| 8 | 226366 | |
| 5 | 225942 | |
| 7 | 224920 |
Latin
| Value | Count | Frequency (%) |
| c | 243876 | |
| a | 236721 | |
| b | 235816 | |
| e | 216428 | |
| f | 214706 | |
| d | 212253 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 3699488 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 1 | 251950 | 6.8% |
| c | 243876 | 6.6% |
| 4 | 243091 | 6.6% |
| 6 | 238193 | 6.4% |
| 0 | 237394 | 6.4% |
| a | 236721 | 6.4% |
| b | 235816 | 6.4% |
| 3 | 235558 | 6.4% |
| 9 | 228810 | 6.2% |
| 2 | 227464 | 6.1% |
| Other values (6) | 1320615 |
| Distinct | 91386 |
|---|---|
| Distinct (%) | 79.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 903.3 KiB |
| Minimum | 2016-09-19 00:15:34 |
|---|---|
| Maximum | 2020-04-09 22:35:08 |
price
Real number (ℝ)
HIGH CORRELATION 
| Distinct | 5879 |
|---|---|
| Distinct (%) | 5.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 120.61985 |
| Minimum | 0.85 |
|---|---|
| Maximum | 6735 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 903.3 KiB |
Quantile statistics
| Minimum | 0.85 |
|---|---|
| 5-th percentile | 17 |
| Q1 | 39.9 |
| median | 74.9 |
| Q3 | 134.9 |
| 95-th percentile | 349.9 |
| Maximum | 6735 |
| Range | 6734.15 |
| Interquartile range (IQR) | 95 |
Descriptive statistics
| Standard deviation | 182.65348 |
|---|---|
| Coefficient of variation (CV) | 1.5142904 |
| Kurtosis | 107.9051 |
| Mean | 120.61985 |
| Median Absolute Deviation (MAD) | 42 |
| Skewness | 7.6154182 |
| Sum | 13944740 |
| Variance | 33362.292 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 59.9 | 2574 | 2.2% |
| 69.9 | 2096 | 1.8% |
| 49.9 | 2013 | 1.7% |
| 89.9 | 1604 | 1.4% |
| 99.9 | 1505 | 1.3% |
| 29.9 | 1362 | 1.2% |
| 39.9 | 1325 | 1.1% |
| 79.9 | 1266 | 1.1% |
| 19.9 | 1263 | 1.1% |
| 29.99 | 1204 | 1.0% |
| Other values (5869) | 99397 |
| Value | Count | Frequency (%) |
| 0.85 | 3 | < 0.1% |
| 1.2 | 20 | |
| 2.2 | 2 | < 0.1% |
| 2.29 | 1 | < 0.1% |
| 2.9 | 1 | < 0.1% |
| 2.99 | 1 | < 0.1% |
| 3.06 | 3 | < 0.1% |
| 3.49 | 3 | < 0.1% |
| 3.5 | 7 | < 0.1% |
| 3.54 | 1 | < 0.1% |
| Value | Count | Frequency (%) |
| 6735 | 1 | |
| 6499 | 1 | |
| 4799 | 1 | |
| 4690 | 1 | |
| 4590 | 1 | |
| 4399.87 | 1 | |
| 4099.99 | 1 | |
| 4059 | 1 | |
| 3999.9 | 1 | |
| 3999 | 2 |
freight_value
Real number (ℝ)
| Distinct | 6954 |
|---|---|
| Distinct (%) | 6.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 20.05688 |
| Minimum | 0 |
|---|---|
| Maximum | 409.68 |
| Zeros | 387 |
| Zeros (%) | 0.3% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 903.3 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 7.78 |
| Q1 | 13.08 |
| median | 16.32 |
| Q3 | 21.21 |
| 95-th percentile | 45.31 |
| Maximum | 409.68 |
| Range | 409.68 |
| Interquartile range (IQR) | 8.13 |
Descriptive statistics
| Standard deviation | 15.836184 |
|---|---|
| Coefficient of variation (CV) | 0.78956371 |
| Kurtosis | 58.250048 |
| Mean | 20.05688 |
| Median Absolute Deviation (MAD) | 3.63 |
| Skewness | 5.5602128 |
| Sum | 2318755.8 |
| Variance | 250.78473 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 15.1 | 3754 | 3.2% |
| 7.78 | 2281 | 2.0% |
| 11.85 | 1948 | 1.7% |
| 14.1 | 1939 | 1.7% |
| 18.23 | 1599 | 1.4% |
| 7.39 | 1554 | 1.3% |
| 16.11 | 1185 | 1.0% |
| 15.23 | 1041 | 0.9% |
| 8.72 | 950 | 0.8% |
| 16.79 | 902 | 0.8% |
| Other values (6944) | 98456 |
| Value | Count | Frequency (%) |
| 0 | 387 | |
| 0.01 | 4 | < 0.1% |
| 0.02 | 3 | < 0.1% |
| 0.03 | 14 | < 0.1% |
| 0.04 | 4 | < 0.1% |
| 0.05 | 3 | < 0.1% |
| 0.06 | 13 | < 0.1% |
| 0.07 | 1 | < 0.1% |
| 0.08 | 12 | < 0.1% |
| 0.09 | 6 | < 0.1% |
| Value | Count | Frequency (%) |
| 409.68 | 1 | |
| 375.28 | 2 | |
| 339.59 | 1 | |
| 338.3 | 1 | |
| 322.1 | 1 | |
| 321.88 | 1 | |
| 321.46 | 1 | |
| 317.47 | 1 | |
| 314.4 | 1 | |
| 314.02 | 1 |
| Distinct | 71 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 903.3 KiB |
Length
| Max length | 46 |
|---|---|
| Median length | 30 |
| Mean length | 14.875062 |
| Min length | 3 |
Characters and Unicode
| Total characters | 1719691 |
|---|---|
| Distinct characters | 28 |
| Distinct categories | 3 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | utilidades_domesticas |
|---|---|
| 2nd row | utilidades_domesticas |
| 3rd row | utilidades_domesticas |
| 4th row | utilidades_domesticas |
| 5th row | utilidades_domesticas |
| Value | Count | Frequency (%) |
| cama_mesa_banho | 11847 | 10.2% |
| beleza_saude | 9944 | 8.6% |
| esporte_lazer | 8942 | 7.7% |
| moveis_decoracao | 8743 | 7.6% |
| informatica_acessorios | 8105 | 7.0% |
| utilidades_domesticas | 7331 | 6.3% |
| relogios_presentes | 6161 | 5.3% |
| telefonia | 4692 | 4.1% |
| ferramentas_jardim | 4558 | 3.9% |
| automotivo | 4356 | 3.8% |
| Other values (61) | 40930 |
Most occurring characters
| Value | Count | Frequency (%) |
| e | 208749 | |
| a | 206939 | |
| s | 171469 | |
| o | 170145 | |
| i | 114273 | 6.6% |
| r | 110581 | 6.4% |
| _ | 109454 | 6.4% |
| t | 82596 | 4.8% |
| c | 81711 | 4.8% |
| m | 77941 | 4.5% |
| Other values (18) | 385833 |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 1609941 | |
| Connector Punctuation | 109454 | 6.4% |
| Decimal Number | 296 | < 0.1% |
Most frequent character per category
Lowercase Letter
| Value | Count | Frequency (%) |
| e | 208749 | |
| a | 206939 | |
| s | 171469 | |
| o | 170145 | |
| i | 114273 | 7.1% |
| r | 110581 | 6.9% |
| t | 82596 | 5.1% |
| c | 81711 | 5.1% |
| m | 77941 | 4.8% |
| n | 58609 | 3.6% |
| Other values (16) | 326928 |
Connector Punctuation
| Value | Count | Frequency (%) |
| _ | 109454 |
Decimal Number
| Value | Count | Frequency (%) |
| 2 | 296 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 1609941 | |
| Common | 109750 | 6.4% |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| e | 208749 | |
| a | 206939 | |
| s | 171469 | |
| o | 170145 | |
| i | 114273 | 7.1% |
| r | 110581 | 6.9% |
| t | 82596 | 5.1% |
| c | 81711 | 5.1% |
| m | 77941 | 4.8% |
| n | 58609 | 3.6% |
| Other values (16) | 326928 |
Common
| Value | Count | Frequency (%) |
| _ | 109454 | |
| 2 | 296 | 0.3% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 1719691 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| e | 208749 | |
| a | 206939 | |
| s | 171469 | |
| o | 170145 | |
| i | 114273 | 6.6% |
| r | 110581 | 6.4% |
| _ | 109454 | 6.4% |
| t | 82596 | 4.8% |
| c | 81711 | 4.8% |
| m | 77941 | 4.5% |
| Other values (18) | 385833 |
product_name_lenght
Real number (ℝ)
| Distinct | 66 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 48.766541 |
| Minimum | 5 |
|---|---|
| Maximum | 76 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 903.3 KiB |
Quantile statistics
| Minimum | 5 |
|---|---|
| 5-th percentile | 29 |
| Q1 | 42 |
| median | 52 |
| Q3 | 57 |
| 95-th percentile | 60 |
| Maximum | 76 |
| Range | 71 |
| Interquartile range (IQR) | 15 |
Descriptive statistics
| Standard deviation | 10.034187 |
|---|---|
| Coefficient of variation (CV) | 0.20575966 |
| Kurtosis | 0.14955291 |
| Mean | 48.766541 |
| Median Absolute Deviation (MAD) | 6 |
| Skewness | -0.90541969 |
| Sum | 5637851 |
| Variance | 100.68491 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 59 | 8598 | 7.4% |
| 60 | 8004 | 6.9% |
| 56 | 6803 | 5.9% |
| 58 | 6753 | 5.8% |
| 57 | 6261 | 5.4% |
| 55 | 5797 | 5.0% |
| 54 | 5469 | 4.7% |
| 53 | 4319 | 3.7% |
| 52 | 4280 | 3.7% |
| 49 | 3670 | 3.2% |
| Other values (56) | 55655 |
| Value | Count | Frequency (%) |
| 5 | 9 | < 0.1% |
| 6 | 3 | < 0.1% |
| 7 | 2 | < 0.1% |
| 8 | 4 | < 0.1% |
| 9 | 14 | < 0.1% |
| 10 | 8 | < 0.1% |
| 11 | 11 | < 0.1% |
| 12 | 37 | |
| 13 | 26 | |
| 14 | 47 |
| Value | Count | Frequency (%) |
| 76 | 1 | < 0.1% |
| 72 | 9 | < 0.1% |
| 69 | 1 | < 0.1% |
| 68 | 1 | < 0.1% |
| 67 | 3 | < 0.1% |
| 66 | 1 | < 0.1% |
| 64 | 170 | 0.1% |
| 63 | 1335 | |
| 62 | 160 | 0.1% |
| 61 | 239 | 0.2% |
product_description_lenght
Real number (ℝ)
| Distinct | 2958 |
|---|---|
| Distinct (%) | 2.6% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 785.8082 |
| Minimum | 4 |
|---|---|
| Maximum | 3992 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 903.3 KiB |
Quantile statistics
| Minimum | 4 |
|---|---|
| 5-th percentile | 160 |
| Q1 | 346 |
| median | 600 |
| Q3 | 983 |
| 95-th percentile | 2120 |
| Maximum | 3992 |
| Range | 3988 |
| Interquartile range (IQR) | 637 |
Descriptive statistics
| Standard deviation | 652.41862 |
|---|---|
| Coefficient of variation (CV) | 0.83025173 |
| Kurtosis | 4.9272446 |
| Mean | 785.8082 |
| Median Absolute Deviation (MAD) | 295 |
| Skewness | 2.011533 |
| Sum | 90846500 |
| Variance | 425650.05 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 341 | 708 | 0.6% |
| 1893 | 664 | 0.6% |
| 348 | 643 | 0.6% |
| 492 | 590 | 0.5% |
| 903 | 588 | 0.5% |
| 245 | 576 | 0.5% |
| 366 | 532 | 0.5% |
| 236 | 513 | 0.4% |
| 340 | 484 | 0.4% |
| 919 | 436 | 0.4% |
| Other values (2948) | 109875 |
| Value | Count | Frequency (%) |
| 4 | 6 | |
| 8 | 2 | < 0.1% |
| 15 | 1 | < 0.1% |
| 20 | 7 | |
| 23 | 1 | < 0.1% |
| 26 | 2 | < 0.1% |
| 27 | 4 | |
| 28 | 2 | < 0.1% |
| 30 | 8 | |
| 31 | 2 | < 0.1% |
| Value | Count | Frequency (%) |
| 3992 | 2 | < 0.1% |
| 3988 | 1 | < 0.1% |
| 3985 | 3 | |
| 3976 | 6 | |
| 3963 | 1 | < 0.1% |
| 3956 | 3 | |
| 3954 | 2 | < 0.1% |
| 3950 | 2 | < 0.1% |
| 3949 | 1 | < 0.1% |
| 3948 | 1 | < 0.1% |
product_photos_qty
Real number (ℝ)
| Distinct | 19 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 2.2053733 |
| Minimum | 1 |
|---|---|
| Maximum | 20 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 903.3 KiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 1 |
| Q1 | 1 |
| median | 1 |
| Q3 | 3 |
| 95-th percentile | 6 |
| Maximum | 20 |
| Range | 19 |
| Interquartile range (IQR) | 2 |
Descriptive statistics
| Standard deviation | 1.717771 |
|---|---|
| Coefficient of variation (CV) | 0.7789026 |
| Kurtosis | 4.8372556 |
| Mean | 2.2053733 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 1.910868 |
| Sum | 254961 |
| Variance | 2.9507372 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 1 | 58429 | |
| 2 | 22894 | 19.8% |
| 3 | 12869 | 11.1% |
| 4 | 8770 | 7.6% |
| 5 | 5558 | 4.8% |
| 6 | 3905 | 3.4% |
| 7 | 1552 | 1.3% |
| 8 | 771 | 0.7% |
| 10 | 353 | 0.3% |
| 9 | 309 | 0.3% |
| Other values (9) | 199 | 0.2% |
| Value | Count | Frequency (%) |
| 1 | 58429 | |
| 2 | 22894 | 19.8% |
| 3 | 12869 | 11.1% |
| 4 | 8770 | 7.6% |
| 5 | 5558 | 4.8% |
| 6 | 3905 | 3.4% |
| 7 | 1552 | 1.3% |
| 8 | 771 | 0.7% |
| 9 | 309 | 0.3% |
| 10 | 353 | 0.3% |
| Value | Count | Frequency (%) |
| 20 | 1 | < 0.1% |
| 19 | 2 | < 0.1% |
| 18 | 4 | < 0.1% |
| 17 | 11 | < 0.1% |
| 15 | 12 | < 0.1% |
| 14 | 6 | < 0.1% |
| 13 | 30 | < 0.1% |
| 12 | 60 | 0.1% |
| 11 | 73 | 0.1% |
| 10 | 353 |
product_weight_g
Real number (ℝ)
HIGH CORRELATION 
| Distinct | 2197 |
|---|---|
| Distinct (%) | 1.9% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 2113.8911 |
| Minimum | 0 |
|---|---|
| Maximum | 40425 |
| Zeros | 8 |
| Zeros (%) | < 0.1% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 903.3 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 125 |
| Q1 | 300 |
| median | 700 |
| Q3 | 1800 |
| 95-th percentile | 9850 |
| Maximum | 40425 |
| Range | 40425 |
| Interquartile range (IQR) | 1500 |
Descriptive statistics
| Standard deviation | 3781.7427 |
|---|---|
| Coefficient of variation (CV) | 1.788996 |
| Kurtosis | 16.034687 |
| Mean | 2113.8911 |
| Median Absolute Deviation (MAD) | 500 |
| Skewness | 3.5806654 |
| Sum | 2.4438484 × 108 |
| Variance | 14301578 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 200 | 6816 | 5.9% |
| 150 | 5329 | 4.6% |
| 250 | 4671 | 4.0% |
| 300 | 4313 | 3.7% |
| 100 | 3571 | 3.1% |
| 400 | 3481 | 3.0% |
| 350 | 3211 | 2.8% |
| 500 | 2787 | 2.4% |
| 600 | 2778 | 2.4% |
| 700 | 2095 | 1.8% |
| Other values (2187) | 76557 |
| Value | Count | Frequency (%) |
| 0 | 8 | < 0.1% |
| 2 | 5 | < 0.1% |
| 25 | 3 | < 0.1% |
| 50 | 985 | |
| 53 | 2 | < 0.1% |
| 54 | 2 | < 0.1% |
| 55 | 2 | < 0.1% |
| 58 | 1 | < 0.1% |
| 60 | 9 | < 0.1% |
| 61 | 5 | < 0.1% |
| Value | Count | Frequency (%) |
| 40425 | 3 | < 0.1% |
| 30000 | 296 | |
| 29800 | 1 | < 0.1% |
| 29750 | 1 | < 0.1% |
| 29700 | 4 | < 0.1% |
| 29600 | 5 | < 0.1% |
| 29500 | 2 | < 0.1% |
| 29250 | 1 | < 0.1% |
| 29150 | 1 | < 0.1% |
| 29100 | 1 | < 0.1% |
product_length_cm
Real number (ℝ)
HIGH CORRELATION 
| Distinct | 99 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 30.307779 |
| Minimum | 7 |
|---|---|
| Maximum | 105 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 903.3 KiB |
Quantile statistics
| Minimum | 7 |
|---|---|
| 5-th percentile | 16 |
| Q1 | 18 |
| median | 25 |
| Q3 | 38 |
| 95-th percentile | 62 |
| Maximum | 105 |
| Range | 98 |
| Interquartile range (IQR) | 20 |
Descriptive statistics
| Standard deviation | 16.211093 |
|---|---|
| Coefficient of variation (CV) | 0.53488225 |
| Kurtosis | 3.6631492 |
| Mean | 30.307779 |
| Median Absolute Deviation (MAD) | 8 |
| Skewness | 1.7425168 |
| Sum | 3503852 |
| Variance | 262.79953 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 16 | 17713 | 15.3% |
| 20 | 10603 | 9.2% |
| 30 | 7814 | 6.8% |
| 17 | 6126 | 5.3% |
| 18 | 5844 | 5.1% |
| 19 | 4845 | 4.2% |
| 25 | 4768 | 4.1% |
| 40 | 4238 | 3.7% |
| 22 | 3935 | 3.4% |
| 50 | 3091 | 2.7% |
| Other values (89) | 46632 |
| Value | Count | Frequency (%) |
| 7 | 32 | < 0.1% |
| 8 | 2 | < 0.1% |
| 9 | 4 | < 0.1% |
| 10 | 8 | < 0.1% |
| 11 | 96 | 0.1% |
| 12 | 41 | < 0.1% |
| 13 | 60 | 0.1% |
| 14 | 137 | 0.1% |
| 15 | 212 | 0.2% |
| 16 | 17713 |
| Value | Count | Frequency (%) |
| 105 | 331 | |
| 104 | 30 | < 0.1% |
| 103 | 45 | < 0.1% |
| 102 | 60 | 0.1% |
| 101 | 108 | 0.1% |
| 100 | 424 | |
| 99 | 36 | < 0.1% |
| 98 | 50 | < 0.1% |
| 97 | 11 | < 0.1% |
| 96 | 8 | < 0.1% |
product_height_cm
Real number (ℝ)
HIGH CORRELATION 
| Distinct | 102 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 16.638419 |
| Minimum | 2 |
|---|---|
| Maximum | 105 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 903.3 KiB |
Quantile statistics
| Minimum | 2 |
|---|---|
| 5-th percentile | 3 |
| Q1 | 8 |
| median | 13 |
| Q3 | 20 |
| 95-th percentile | 45 |
| Maximum | 105 |
| Range | 103 |
| Interquartile range (IQR) | 12 |
Descriptive statistics
| Standard deviation | 13.473526 |
|---|---|
| Coefficient of variation (CV) | 0.80978399 |
| Kurtosis | 7.2875923 |
| Mean | 16.638419 |
| Median Absolute Deviation (MAD) | 6 |
| Skewness | 2.2431354 |
| Sum | 1923551 |
| Variance | 181.53589 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 10 | 10209 | 8.8% |
| 20 | 6796 | 5.9% |
| 15 | 6784 | 5.9% |
| 11 | 6309 | 5.5% |
| 12 | 6196 | 5.4% |
| 2 | 5097 | 4.4% |
| 4 | 4778 | 4.1% |
| 8 | 4773 | 4.1% |
| 16 | 4661 | 4.0% |
| 5 | 4636 | 4.0% |
| Other values (92) | 55370 |
| Value | Count | Frequency (%) |
| 2 | 5097 | |
| 3 | 2770 | 2.4% |
| 4 | 4778 | |
| 5 | 4636 | |
| 6 | 3511 | 3.0% |
| 7 | 4217 | |
| 8 | 4773 | |
| 9 | 3369 | 2.9% |
| 10 | 10209 | |
| 11 | 6309 |
| Value | Count | Frequency (%) |
| 105 | 137 | |
| 104 | 14 | < 0.1% |
| 103 | 49 | < 0.1% |
| 102 | 10 | < 0.1% |
| 100 | 42 | < 0.1% |
| 99 | 5 | < 0.1% |
| 98 | 3 | < 0.1% |
| 97 | 2 | < 0.1% |
| 96 | 8 | < 0.1% |
| 95 | 22 | < 0.1% |
product_width_cm
Real number (ℝ)
HIGH CORRELATION 
| Distinct | 95 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 23.11314 |
| Minimum | 6 |
|---|---|
| Maximum | 118 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 903.3 KiB |
Quantile statistics
| Minimum | 6 |
|---|---|
| 5-th percentile | 11 |
| Q1 | 15 |
| median | 20 |
| Q3 | 30 |
| 95-th percentile | 45 |
| Maximum | 118 |
| Range | 112 |
| Interquartile range (IQR) | 15 |
Descriptive statistics
| Standard deviation | 11.755036 |
|---|---|
| Coefficient of variation (CV) | 0.50858672 |
| Kurtosis | 4.5532615 |
| Mean | 23.11314 |
| Median Absolute Deviation (MAD) | 6 |
| Skewness | 1.7072296 |
| Sum | 2672087 |
| Variance | 138.18087 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 20 | 12448 | 10.8% |
| 11 | 10662 | 9.2% |
| 15 | 8964 | 7.8% |
| 16 | 8677 | 7.5% |
| 30 | 7880 | 6.8% |
| 12 | 5590 | 4.8% |
| 13 | 5412 | 4.7% |
| 14 | 4753 | 4.1% |
| 18 | 4122 | 3.6% |
| 40 | 4042 | 3.5% |
| Other values (85) | 43059 |
| Value | Count | Frequency (%) |
| 6 | 2 | < 0.1% |
| 7 | 5 | < 0.1% |
| 8 | 29 | < 0.1% |
| 9 | 51 | < 0.1% |
| 10 | 83 | 0.1% |
| 11 | 10662 | |
| 12 | 5590 | |
| 13 | 5412 | |
| 14 | 4753 | |
| 15 | 8964 |
| Value | Count | Frequency (%) |
| 118 | 7 | < 0.1% |
| 105 | 14 | < 0.1% |
| 104 | 1 | < 0.1% |
| 103 | 1 | < 0.1% |
| 102 | 2 | < 0.1% |
| 101 | 2 | < 0.1% |
| 100 | 43 | |
| 98 | 1 | < 0.1% |
| 97 | 1 | < 0.1% |
| 95 | 2 | < 0.1% |
| Distinct | 71 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 903.3 KiB |
Length
| Max length | 39 |
|---|---|
| Median length | 31 |
| Mean length | 12.989949 |
| Min length | 3 |
Characters and Unicode
| Total characters | 1501755 |
|---|---|
| Distinct characters | 25 |
| Distinct categories | 3 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | housewares |
|---|---|
| 2nd row | housewares |
| 3rd row | housewares |
| 4th row | housewares |
| 5th row | housewares |
| Value | Count | Frequency (%) |
| bed_bath_table | 11847 | 10.2% |
| health_beauty | 9944 | 8.6% |
| sports_leisure | 8942 | 7.7% |
| furniture_decor | 8743 | 7.6% |
| computers_accessories | 8105 | 7.0% |
| housewares | 7331 | 6.3% |
| watches_gifts | 6161 | 5.3% |
| telephony | 4692 | 4.1% |
| garden_tools | 4558 | 3.9% |
| auto | 4356 | 3.8% |
| Other values (61) | 40930 |
Most occurring characters
| Value | Count | Frequency (%) |
| e | 183852 | |
| s | 141050 | 9.4% |
| t | 132154 | 8.8% |
| o | 111010 | 7.4% |
| r | 105008 | 7.0% |
| a | 101597 | 6.8% |
| _ | 101311 | 6.7% |
| u | 77584 | 5.2% |
| c | 71956 | 4.8% |
| i | 62806 | 4.2% |
| Other values (15) | 413427 |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 1400148 | |
| Connector Punctuation | 101311 | 6.7% |
| Decimal Number | 296 | < 0.1% |
Most frequent character per category
Lowercase Letter
| Value | Count | Frequency (%) |
| e | 183852 | |
| s | 141050 | 10.1% |
| t | 132154 | 9.4% |
| o | 111010 | 7.9% |
| r | 105008 | 7.5% |
| a | 101597 | 7.3% |
| u | 77584 | 5.5% |
| c | 71956 | 5.1% |
| i | 62806 | 4.5% |
| h | 59142 | 4.2% |
| Other values (13) | 353989 |
Connector Punctuation
| Value | Count | Frequency (%) |
| _ | 101311 |
Decimal Number
| Value | Count | Frequency (%) |
| 2 | 296 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 1400148 | |
| Common | 101607 | 6.8% |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| e | 183852 | |
| s | 141050 | 10.1% |
| t | 132154 | 9.4% |
| o | 111010 | 7.9% |
| r | 105008 | 7.5% |
| a | 101597 | 7.3% |
| u | 77584 | 5.5% |
| c | 71956 | 5.1% |
| i | 62806 | 4.5% |
| h | 59142 | 4.2% |
| Other values (13) | 353989 |
Common
| Value | Count | Frequency (%) |
| _ | 101311 | |
| 2 | 296 | 0.3% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 1501755 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| e | 183852 | |
| s | 141050 | 9.4% |
| t | 132154 | 8.8% |
| o | 111010 | 7.4% |
| r | 105008 | 7.0% |
| a | 101597 | 6.8% |
| _ | 101311 | 6.7% |
| u | 77584 | 5.2% |
| c | 71956 | 4.8% |
| i | 62806 | 4.2% |
| Other values (15) | 413427 |
review_score
Categorical
| Distinct | 5 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 903.3 KiB |
| 5 | |
|---|---|
| 4 | |
| 1 | |
| 3 | |
| 2 | 4020 |
Length
| Max length | 1 |
|---|---|
| Median length | 1 |
| Mean length | 1 |
| Min length | 1 |
Characters and Unicode
| Total characters | 115609 |
|---|---|
| Distinct characters | 5 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 4 |
|---|---|
| 2nd row | 4 |
| 3rd row | 4 |
| 4th row | 4 |
| 5th row | 5 |
Common Values
| Value | Count | Frequency (%) |
| 5 | 65374 | |
| 4 | 21951 | 19.0% |
| 1 | 14546 | 12.6% |
| 3 | 9718 | 8.4% |
| 2 | 4020 | 3.5% |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| 5 | 65374 | |
| 4 | 21951 | 19.0% |
| 1 | 14546 | 12.6% |
| 3 | 9718 | 8.4% |
| 2 | 4020 | 3.5% |
Most occurring characters
| Value | Count | Frequency (%) |
| 5 | 65374 | |
| 4 | 21951 | 19.0% |
| 1 | 14546 | 12.6% |
| 3 | 9718 | 8.4% |
| 2 | 4020 | 3.5% |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 115609 |
Most frequent character per category
Decimal Number
| Value | Count | Frequency (%) |
| 5 | 65374 | |
| 4 | 21951 | 19.0% |
| 1 | 14546 | 12.6% |
| 3 | 9718 | 8.4% |
| 2 | 4020 | 3.5% |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 115609 |
Most frequent character per script
Common
| Value | Count | Frequency (%) |
| 5 | 65374 | |
| 4 | 21951 | 19.0% |
| 1 | 14546 | 12.6% |
| 3 | 9718 | 8.4% |
| 2 | 4020 | 3.5% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 115609 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 5 | 65374 | |
| 4 | 21951 | 19.0% |
| 1 | 14546 | 12.6% |
| 3 | 9718 | 8.4% |
| 2 | 4020 | 3.5% |
| Distinct | 35177 |
|---|---|
| Distinct (%) | 30.4% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 903.3 KiB |
Length
| Max length | 208 |
|---|---|
| Median length | 10 |
| Mean length | 35.468545 |
| Min length | 1 |
Characters and Unicode
| Total characters | 4100483 |
|---|---|
| Distinct characters | 205 |
| Distinct categories | 15 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 3 ? |
Unique
| Unique | 28730 ? |
|---|---|
| Unique (%) | 24.9% |
Sample
| 1st row | Não testei o produto ainda, mas ele veio correto e em boas condições. Apenas a caixa que veio bem amassada e danificada, o que ficará chato, pois se trata de um presente. |
|---|---|
| 2nd row | Não testei o produto ainda, mas ele veio correto e em boas condições. Apenas a caixa que veio bem amassada e danificada, o que ficará chato, pois se trata de um presente. |
| 3rd row | Não testei o produto ainda, mas ele veio correto e em boas condições. Apenas a caixa que veio bem amassada e danificada, o que ficará chato, pois se trata de um presente. |
| 4th row | Deveriam embalar melhor o produto. A caixa veio toda amassada e vou dar de presente. |
| 5th row | Só achei ela pequena pra seis xícaras ,mais é um bom produto |
| Value | Count | Frequency (%) |
| no | 72661 | 10.1% |
| reviews | 66703 | 9.3% |
| o | 22075 | 3.1% |
| produto | 20487 | 2.8% |
| e | 19397 | 2.7% |
| a | 14735 | 2.0% |
| de | 14075 | 2.0% |
| do | 12785 | 1.8% |
| não | 12702 | 1.8% |
| que | 10115 | 1.4% |
| Other values (19330) | 453824 |
Most occurring characters
| Value | Count | Frequency (%) |
| 610307 | ||
| e | 462494 | 11.3% |
| o | 405605 | 9.9% |
| a | 272669 | 6.6% |
| r | 260310 | 6.3% |
| i | 225166 | 5.5% |
| s | 196336 | 4.8% |
| t | 156573 | 3.8% |
| d | 145458 | 3.5% |
| n | 133224 | 3.2% |
| Other values (195) | 1232341 |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 3129103 | |
| Space Separator | 610307 | 14.9% |
| Uppercase Letter | 229112 | 5.6% |
| Other Punctuation | 93611 | 2.3% |
| Decimal Number | 21346 | 0.5% |
| Control | 13578 | 0.3% |
| Dash Punctuation | 943 | < 0.1% |
| Close Punctuation | 718 | < 0.1% |
| Open Punctuation | 701 | < 0.1% |
| Other Symbol | 690 | < 0.1% |
| Other values (5) | 374 | < 0.1% |
Most frequent character per category
Other Symbol
| Value | Count | Frequency (%) |
| 👏 | 241 | |
| 👍 | 86 | 12.5% |
| 😍 | 74 | 10.7% |
| ° | 27 | 3.9% |
| 😉 | 22 | 3.2% |
| 😘 | 20 | 2.9% |
| 😆 | 19 | 2.8% |
| 😡 | 18 | 2.6% |
| 😁 | 13 | 1.9% |
| 👎 | 13 | 1.9% |
| Other values (51) | 157 |
Lowercase Letter
| Value | Count | Frequency (%) |
| e | 462494 | |
| o | 405605 | |
| a | 272669 | 8.7% |
| r | 260310 | 8.3% |
| i | 225166 | 7.2% |
| s | 196336 | 6.3% |
| t | 156573 | 5.0% |
| d | 145458 | 4.6% |
| n | 133224 | 4.3% |
| m | 124354 | 4.0% |
| Other values (40) | 746914 |
Uppercase Letter
| Value | Count | Frequency (%) |
| N | 75942 | |
| E | 19186 | 8.4% |
| O | 18074 | 7.9% |
| A | 16813 | 7.3% |
| P | 12154 | 5.3% |
| R | 11806 | 5.2% |
| C | 9540 | 4.2% |
| M | 9162 | 4.0% |
| S | 8085 | 3.5% |
| T | 7584 | 3.3% |
| Other values (31) | 40766 |
Other Punctuation
| Value | Count | Frequency (%) |
| . | 49261 | |
| , | 27288 | |
| ! | 12446 | 13.3% |
| / | 1787 | 1.9% |
| ? | 1566 | 1.7% |
| " | 410 | 0.4% |
| : | 301 | 0.3% |
| ; | 222 | 0.2% |
| % | 192 | 0.2% |
| * | 72 | 0.1% |
| Other values (5) | 66 | 0.1% |
Decimal Number
| Value | Count | Frequency (%) |
| 0 | 4919 | |
| 1 | 4891 | |
| 2 | 4095 | |
| 3 | 1917 | 9.0% |
| 4 | 1328 | 6.2% |
| 5 | 1223 | 5.7% |
| 8 | 921 | 4.3% |
| 6 | 877 | 4.1% |
| 7 | 717 | 3.4% |
| 9 | 458 | 2.1% |
Math Symbol
| Value | Count | Frequency (%) |
| + | 88 | |
| = | 27 | 18.8% |
| | | 12 | 8.3% |
| < | 9 | 6.2% |
| ~ | 3 | 2.1% |
| × | 2 | 1.4% |
| > | 2 | 1.4% |
| ÷ | 1 | 0.7% |
Modifier Symbol
| Value | Count | Frequency (%) |
| 🏻 | 34 | |
| ´ | 26 | |
| 🏼 | 15 | |
| 🏽 | 13 | 12.7% |
| ^ | 8 | 7.8% |
| 🏾 | 4 | 3.9% |
| ` | 2 | 2.0% |
Control
| Value | Count | Frequency (%) |
| 6779 | ||
| 6779 | ||
| 20 | 0.1% |
Close Punctuation
| Value | Count | Frequency (%) |
| ) | 715 | |
| ] | 3 | 0.4% |
Open Punctuation
| Value | Count | Frequency (%) |
| ( | 695 | |
| [ | 6 | 0.9% |
Other Letter
| Value | Count | Frequency (%) |
| º | 24 | |
| ª | 19 |
Space Separator
| Value | Count | Frequency (%) |
| 610307 |
Dash Punctuation
| Value | Count | Frequency (%) |
| - | 943 |
Currency Symbol
| Value | Count | Frequency (%) |
| $ | 77 |
Connector Punctuation
| Value | Count | Frequency (%) |
| _ | 8 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 3358258 | |
| Common | 742225 | 18.1% |
Most frequent character per script
Common
| Value | Count | Frequency (%) |
| 610307 | ||
| . | 49261 | 6.6% |
| , | 27288 | 3.7% |
| ! | 12446 | 1.7% |
| 6779 | 0.9% | |
| 6779 | 0.9% | |
| 0 | 4919 | 0.7% |
| 1 | 4891 | 0.7% |
| 2 | 4095 | 0.6% |
| 3 | 1917 | 0.3% |
| Other values (102) | 13543 | 1.8% |
Latin
| Value | Count | Frequency (%) |
| e | 462494 | |
| o | 405605 | |
| a | 272669 | 8.1% |
| r | 260310 | 7.8% |
| i | 225166 | 6.7% |
| s | 196336 | 5.8% |
| t | 156573 | 4.7% |
| d | 145458 | 4.3% |
| n | 133224 | 4.0% |
| m | 124354 | 3.7% |
| Other values (83) | 976069 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 4038188 | |
| None | 62050 | 1.5% |
| Emoticons | 245 | < 0.1% |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 610307 | ||
| e | 462494 | 11.5% |
| o | 405605 | 10.0% |
| a | 272669 | 6.8% |
| r | 260310 | 6.4% |
| i | 225166 | 5.6% |
| s | 196336 | 4.9% |
| t | 156573 | 3.9% |
| d | 145458 | 3.6% |
| n | 133224 | 3.3% |
| Other values (85) | 1170046 |
None
| Value | Count | Frequency (%) |
| ã | 18253 | |
| é | 11197 | |
| á | 8923 | |
| ç | 7252 | 11.7% |
| ó | 6189 | 10.0% |
| ê | 1902 | 3.1% |
| í | 1714 | 2.8% |
| Ó | 1543 | 2.5% |
| õ | 908 | 1.5% |
| ú | 886 | 1.4% |
| Other values (71) | 3283 | 5.3% |
Emoticons
| Value | Count | Frequency (%) |
| 😍 | 74 | |
| 😉 | 22 | 9.0% |
| 😘 | 20 | 8.2% |
| 😆 | 19 | 7.8% |
| 😡 | 18 | 7.3% |
| 😁 | 13 | 5.3% |
| 😊 | 12 | 4.9% |
| 😀 | 8 | 3.3% |
| 😩 | 7 | 2.9% |
| 😃 | 6 | 2.4% |
| Other values (19) | 46 |
| payment_sequential | payment_installments | payment_value | customer_zip_code_prefix | order_item_id | price | freight_value | product_name_lenght | product_description_lenght | product_photos_qty | product_weight_g | product_length_cm | product_height_cm | product_width_cm | order_status | payment_type | customer_state | review_score | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| payment_sequential | 1.000 | -0.177 | -0.214 | -0.007 | -0.007 | -0.005 | 0.016 | -0.004 | -0.013 | -0.004 | 0.028 | 0.032 | 0.011 | 0.026 | 0.029 | 0.229 | 0.026 | 0.012 |
| payment_installments | -0.177 | 1.000 | 0.396 | 0.069 | 0.060 | 0.317 | 0.190 | 0.016 | 0.033 | -0.003 | 0.198 | 0.109 | 0.106 | 0.125 | 0.005 | 0.273 | 0.032 | 0.028 |
| payment_value | -0.214 | 0.396 | 1.000 | 0.106 | 0.257 | 0.790 | 0.424 | 0.024 | 0.169 | -0.012 | 0.452 | 0.231 | 0.306 | 0.234 | 0.016 | 0.021 | 0.027 | 0.028 |
| customer_zip_code_prefix | -0.007 | 0.069 | 0.106 | 1.000 | -0.009 | 0.070 | 0.466 | 0.016 | 0.031 | 0.026 | 0.026 | 0.009 | 0.019 | -0.002 | 0.023 | 0.033 | 0.896 | 0.042 |
| order_item_id | -0.007 | 0.060 | 0.257 | -0.009 | 1.000 | -0.114 | -0.056 | -0.022 | -0.032 | -0.064 | 0.001 | 0.008 | 0.019 | -0.003 | 0.003 | 0.021 | 0.003 | 0.041 |
| price | -0.005 | 0.317 | 0.790 | 0.070 | -0.114 | 1.000 | 0.435 | 0.042 | 0.211 | 0.028 | 0.515 | 0.268 | 0.328 | 0.273 | 0.015 | 0.014 | 0.020 | 0.012 |
| freight_value | 0.016 | 0.190 | 0.424 | 0.466 | -0.056 | 0.435 | 1.000 | 0.033 | 0.117 | 0.010 | 0.448 | 0.282 | 0.284 | 0.273 | 0.016 | 0.010 | 0.085 | 0.015 |
| product_name_lenght | -0.004 | 0.016 | 0.024 | 0.016 | -0.022 | 0.042 | 0.033 | 1.000 | 0.073 | 0.163 | 0.076 | 0.060 | -0.057 | 0.066 | 0.019 | 0.011 | 0.013 | 0.013 |
| product_description_lenght | -0.013 | 0.033 | 0.169 | 0.031 | -0.032 | 0.211 | 0.117 | 0.073 | 1.000 | 0.111 | 0.095 | -0.020 | 0.134 | -0.081 | 0.017 | 0.020 | 0.027 | 0.015 |
| product_photos_qty | -0.004 | -0.003 | -0.012 | 0.026 | -0.064 | 0.028 | 0.010 | 0.163 | 0.111 | 1.000 | 0.003 | 0.005 | -0.080 | -0.015 | 0.013 | 0.004 | 0.014 | 0.016 |
| product_weight_g | 0.028 | 0.198 | 0.452 | 0.026 | 0.001 | 0.515 | 0.448 | 0.076 | 0.095 | 0.003 | 1.000 | 0.618 | 0.530 | 0.619 | 0.012 | 0.017 | 0.028 | 0.021 |
| product_length_cm | 0.032 | 0.109 | 0.231 | 0.009 | 0.008 | 0.268 | 0.282 | 0.060 | -0.020 | 0.005 | 0.618 | 1.000 | 0.244 | 0.631 | 0.015 | 0.021 | 0.017 | 0.018 |
| product_height_cm | 0.011 | 0.106 | 0.306 | 0.019 | 0.019 | 0.328 | 0.284 | -0.057 | 0.134 | -0.080 | 0.530 | 0.244 | 1.000 | 0.334 | 0.016 | 0.015 | 0.020 | 0.018 |
| product_width_cm | 0.026 | 0.125 | 0.234 | -0.002 | -0.003 | 0.273 | 0.273 | 0.066 | -0.081 | -0.015 | 0.619 | 0.631 | 0.334 | 1.000 | 0.005 | 0.019 | 0.017 | 0.013 |
| order_status | 0.029 | 0.005 | 0.016 | 0.023 | 0.003 | 0.015 | 0.016 | 0.019 | 0.017 | 0.013 | 0.012 | 0.015 | 0.016 | 0.005 | 1.000 | 0.007 | 0.027 | 0.131 |
| payment_type | 0.229 | 0.273 | 0.021 | 0.033 | 0.021 | 0.014 | 0.010 | 0.011 | 0.020 | 0.004 | 0.017 | 0.021 | 0.015 | 0.019 | 0.007 | 1.000 | 0.039 | 0.009 |
| customer_state | 0.026 | 0.032 | 0.027 | 0.896 | 0.003 | 0.020 | 0.085 | 0.013 | 0.027 | 0.014 | 0.028 | 0.017 | 0.020 | 0.017 | 0.027 | 0.039 | 1.000 | 0.049 |
| review_score | 0.012 | 0.028 | 0.028 | 0.042 | 0.041 | 0.012 | 0.015 | 0.013 | 0.015 | 0.016 | 0.021 | 0.018 | 0.018 | 0.013 | 0.131 | 0.009 | 0.049 | 1.000 |
| order_id | customer_id | order_status | payment_sequential | payment_type | payment_installments | payment_value | customer_unique_id | customer_zip_code_prefix | customer_city | customer_state | order_item_id | product_id | seller_id | shipping_limit_date | price | freight_value | product_category_name | product_name_lenght | product_description_lenght | product_photos_qty | product_weight_g | product_length_cm | product_height_cm | product_width_cm | product_category_name_english | review_score | review_comment_message | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | e481f51cbdc54678b7cc49136f2d6af7 | 9ef432eb6251297304e76186b10a928d | delivered | 1 | credit_card | 1 | 18.12 | 7c396fd4830fd04220f754e42b4e5bff | 3149 | sao paulo | SP | 1 | 87285b34884572647811a353c7ac498a | 3504c0cb71d7fa48d967e0e4c94d59d9 | 2017-10-06 11:07:15 | 29.99 | 8.72 | utilidades_domesticas | 40.0 | 268.0 | 4.0 | 500.0 | 19.0 | 8.0 | 13.0 | housewares | 4 | Não testei o produto ainda, mas ele veio correto e em boas condições. Apenas a caixa que veio bem amassada e danificada, o que ficará chato, pois se trata de um presente. |
| 1 | e481f51cbdc54678b7cc49136f2d6af7 | 9ef432eb6251297304e76186b10a928d | delivered | 3 | voucher | 1 | 2.00 | 7c396fd4830fd04220f754e42b4e5bff | 3149 | sao paulo | SP | 1 | 87285b34884572647811a353c7ac498a | 3504c0cb71d7fa48d967e0e4c94d59d9 | 2017-10-06 11:07:15 | 29.99 | 8.72 | utilidades_domesticas | 40.0 | 268.0 | 4.0 | 500.0 | 19.0 | 8.0 | 13.0 | housewares | 4 | Não testei o produto ainda, mas ele veio correto e em boas condições. Apenas a caixa que veio bem amassada e danificada, o que ficará chato, pois se trata de um presente. |
| 2 | e481f51cbdc54678b7cc49136f2d6af7 | 9ef432eb6251297304e76186b10a928d | delivered | 2 | voucher | 1 | 18.59 | 7c396fd4830fd04220f754e42b4e5bff | 3149 | sao paulo | SP | 1 | 87285b34884572647811a353c7ac498a | 3504c0cb71d7fa48d967e0e4c94d59d9 | 2017-10-06 11:07:15 | 29.99 | 8.72 | utilidades_domesticas | 40.0 | 268.0 | 4.0 | 500.0 | 19.0 | 8.0 | 13.0 | housewares | 4 | Não testei o produto ainda, mas ele veio correto e em boas condições. Apenas a caixa que veio bem amassada e danificada, o que ficará chato, pois se trata de um presente. |
| 3 | 128e10d95713541c87cd1a2e48201934 | a20e8105f23924cd00833fd87daa0831 | delivered | 1 | credit_card | 3 | 37.77 | 3a51803cc0d012c3b5dc8b7528cb05f7 | 3366 | sao paulo | SP | 1 | 87285b34884572647811a353c7ac498a | 3504c0cb71d7fa48d967e0e4c94d59d9 | 2017-08-21 20:05:16 | 29.99 | 7.78 | utilidades_domesticas | 40.0 | 268.0 | 4.0 | 500.0 | 19.0 | 8.0 | 13.0 | housewares | 4 | Deveriam embalar melhor o produto. A caixa veio toda amassada e vou dar de presente. |
| 4 | 0e7e841ddf8f8f2de2bad69267ecfbcf | 26c7ac168e1433912a51b924fbd34d34 | delivered | 1 | credit_card | 1 | 37.77 | ef0996a1a279c26e7ecbd737be23d235 | 2290 | sao paulo | SP | 1 | 87285b34884572647811a353c7ac498a | 3504c0cb71d7fa48d967e0e4c94d59d9 | 2017-08-08 18:37:31 | 29.99 | 7.78 | utilidades_domesticas | 40.0 | 268.0 | 4.0 | 500.0 | 19.0 | 8.0 | 13.0 | housewares | 5 | Só achei ela pequena pra seis xícaras ,mais é um bom produto\r\n |
| 5 | bfc39df4f36c3693ff3b63fcbea9e90a | 53904ddbea91e1e92b2b3f1d09a7af86 | delivered | 1 | boleto | 1 | 44.09 | e781fdcc107d13d865fc7698711cc572 | 88032 | florianopolis | SC | 1 | 87285b34884572647811a353c7ac498a | 3504c0cb71d7fa48d967e0e4c94d59d9 | 2017-10-31 02:14:11 | 29.99 | 14.10 | utilidades_domesticas | 40.0 | 268.0 | 4.0 | 500.0 | 19.0 | 8.0 | 13.0 | housewares | 3 | No reviews |
| 6 | 6ea2f835b4556291ffdc53fa0b3b95e8 | c7340080e394356141681bd4c9b8fe31 | delivered | 1 | credit_card | 10 | 356.12 | 3e4fd73f1e86b135b9b121d6abbe9597 | 19400 | presidente venceslau | SP | 1 | be021417a6acb56b9b50d3fd2714baa8 | f5f46307a4d15880ca14fab4ad9dfc9b | 2017-11-30 00:21:09 | 339.00 | 17.12 | utilidades_domesticas | 48.0 | 664.0 | 6.0 | 14300.0 | 38.0 | 34.0 | 34.0 | housewares | 1 | Inicialmente, na data da compra o produto era para ser entregue até 21/12. Hoje é dia 27/12 e não chegou ainda. |
| 7 | 82bce245b1c9148f8d19a55b9ff70644 | 388025bec8128ff20ec1a316ed4dcf02 | delivered | 1 | boleto | 1 | 267.80 | f9effeed3df9ae063a58c0759b96f8b2 | 85804 | cascavel | PR | 1 | a5a0e71a81ae65aa335e71c06261e260 | c8417879a15366a17c30af34c798c332 | 2017-04-27 05:15:56 | 38.00 | 15.56 | utilidades_domesticas | 57.0 | 698.0 | 3.0 | 705.0 | 34.0 | 22.0 | 28.0 | housewares | 1 | No reviews |
| 8 | 82bce245b1c9148f8d19a55b9ff70644 | 388025bec8128ff20ec1a316ed4dcf02 | delivered | 1 | boleto | 1 | 267.80 | f9effeed3df9ae063a58c0759b96f8b2 | 85804 | cascavel | PR | 2 | a5a0e71a81ae65aa335e71c06261e260 | c8417879a15366a17c30af34c798c332 | 2017-04-27 05:15:56 | 38.00 | 15.56 | utilidades_domesticas | 57.0 | 698.0 | 3.0 | 705.0 | 34.0 | 22.0 | 28.0 | housewares | 1 | No reviews |
| 9 | 82bce245b1c9148f8d19a55b9ff70644 | 388025bec8128ff20ec1a316ed4dcf02 | delivered | 1 | boleto | 1 | 267.80 | f9effeed3df9ae063a58c0759b96f8b2 | 85804 | cascavel | PR | 3 | a5a0e71a81ae65aa335e71c06261e260 | c8417879a15366a17c30af34c798c332 | 2017-04-27 05:15:56 | 38.00 | 15.56 | utilidades_domesticas | 57.0 | 698.0 | 3.0 | 705.0 | 34.0 | 22.0 | 28.0 | housewares | 1 | No reviews |
| order_id | customer_id | order_status | payment_sequential | payment_type | payment_installments | payment_value | customer_unique_id | customer_zip_code_prefix | customer_city | customer_state | order_item_id | product_id | seller_id | shipping_limit_date | price | freight_value | product_category_name | product_name_lenght | product_description_lenght | product_photos_qty | product_weight_g | product_length_cm | product_height_cm | product_width_cm | product_category_name_english | review_score | review_comment_message | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 115599 | 9980064d9817bacc9e261e7f5fcf3fe5 | e30e0257e1c7189e6f6ba4ef151e717c | delivered | 1 | credit_card | 7 | 145.56 | 56c8638e7c058b98aae6d74d2dd6ea23 | 37800 | guaxupe | MG | 1 | ec90895370885d025efeb8e72e7fa699 | e7f3bf1ecd8526eb7f3b18059e6716e5 | 2017-07-18 07:03:41 | 129.90 | 15.66 | artes_e_artesanato | 57.0 | 283.0 | 1.0 | 1200.0 | 20.0 | 20.0 | 16.0 | arts_and_craftmanship | 5 | No reviews |
| 115600 | 4ec2eea90506ad5dd1284a1a7e4cafee | edb3ca904a6cd3caeecda1f844ebae65 | delivered | 1 | credit_card | 1 | 41.13 | 0f8dc6a031c49afe5079f92f04c798c3 | 4317 | sao paulo | SP | 1 | c51fd9478d188180d962c7ecc35b42d0 | e819bcfade7b5d88a27325eb6cfd62c5 | 2018-08-01 10:45:15 | 29.90 | 11.23 | artes_e_artesanato | 44.0 | 447.0 | 4.0 | 2900.0 | 50.0 | 10.0 | 40.0 | arts_and_craftmanship | 5 | Muito bonito, chegou no prazo. Poderiam ter indicado o número do pedido na embalagem para saber! |
| 115601 | 31a2886d02ad2127bfec204da2e93b66 | 28738edfba72391be47d697e6e7e5770 | delivered | 1 | credit_card | 1 | 27.20 | e839774c9d31569dba47946296e58b33 | 11035 | santos | SP | 1 | 3a96bcbf644a5d390107570628568026 | 70126eecc6aa1274392a1743866e9678 | 2018-07-31 10:35:17 | 19.80 | 7.40 | artes_e_artesanato | 53.0 | 529.0 | 2.0 | 325.0 | 27.0 | 10.0 | 14.0 | arts_and_craftmanship | 5 | Chegou muito, muito antes do prazo |
| 115602 | 1c3f752b9a4d09bf1e016439a427d5f8 | 7fe022a904d647429c6e08a8f34c9b22 | delivered | 1 | debit_card | 1 | 23.88 | 931a4a1a3e2cf8b4b4d33922f1469dbe | 12243 | sao jose dos campos | SP | 1 | 56a1efb30499b4dffd45c8d655199b11 | 55f7a3319d80f7fdf078b8f03e6725fe | 2018-08-20 23:35:14 | 16.49 | 7.39 | artes_e_artesanato | 60.0 | 778.0 | 2.0 | 100.0 | 22.0 | 2.0 | 15.0 | arts_and_craftmanship | 5 | No reviews |
| 115603 | 2cfc3681e512e0d12b6fe84b396e3907 | 6c60b00bcbef919c1697d18c309a99fe | delivered | 1 | credit_card | 1 | 34.22 | 4637328fb3cc446c747c7f83f80c651d | 38401 | uberlandia | MG | 1 | 1cf657de01c2b973b898ad0ac9073ac7 | fd386aa7bed2af3c7035c65506c9b4a3 | 2018-04-26 21:31:05 | 15.99 | 18.23 | artes_e_artesanato | 41.0 | 130.0 | 1.0 | 210.0 | 25.0 | 10.0 | 15.0 | arts_and_craftmanship | 4 | No reviews |
| 115604 | 0b82d0616f1ad8da15cf967b984b4004 | 986632b40c38f4240caf8608cb01d40d | delivered | 1 | boleto | 1 | 33.69 | c887bc0b0717ee4a21d7d22137f12ee3 | 30575 | belo horizonte | MG | 1 | 4a24717893a6c8f3cfcf9843b8987d15 | 2cb6eb1b7185064167657fa09f541105 | 2018-08-07 04:25:14 | 25.00 | 8.69 | artes_e_artesanato | 36.0 | 576.0 | 5.0 | 350.0 | 32.0 | 2.0 | 28.0 | arts_and_craftmanship | 5 | No reviews |
| 115605 | 2ef4a11b6e24fdfbb43b92cb5f95edff | ee1cfdc92e449920e25d3ca4ab4da4f6 | delivered | 1 | credit_card | 1 | 84.63 | 8d80e477643ec569b24592ce3d9dfc4c | 9951 | diadema | SP | 1 | 9c313adb4b38a55b092f53f83f78be9e | ef728fa1f17436c91ed1ccd03dcf9631 | 2018-07-30 09:17:39 | 19.00 | 12.86 | artes_e_artesanato | 32.0 | 660.0 | 3.0 | 500.0 | 16.0 | 6.0 | 16.0 | arts_and_craftmanship | 3 | Um dos frisadores que comprei, especificamente a FOLHA NAO FRISA! NAO REALIZA SUA FUNÇAO. Nao molda o eva, Testei com varios materiais diferentes e infelizmente nao funciona. |
| 115606 | 2ef4a11b6e24fdfbb43b92cb5f95edff | ee1cfdc92e449920e25d3ca4ab4da4f6 | delivered | 1 | credit_card | 1 | 84.63 | 8d80e477643ec569b24592ce3d9dfc4c | 9951 | diadema | SP | 2 | eacb104882d39ffb53140b1d1860a7c3 | ef728fa1f17436c91ed1ccd03dcf9631 | 2018-07-30 09:17:39 | 39.90 | 12.87 | artes_e_artesanato | 57.0 | 942.0 | 5.0 | 500.0 | 21.0 | 7.0 | 14.0 | arts_and_craftmanship | 3 | Um dos frisadores que comprei, especificamente a FOLHA NAO FRISA! NAO REALIZA SUA FUNÇAO. Nao molda o eva, Testei com varios materiais diferentes e infelizmente nao funciona. |
| 115607 | 2c4ada2e75c2ad41dd93cebb5df5f023 | 363d3a9b2ec5c5426608688ca033292d | delivered | 1 | credit_card | 1 | 209.06 | d8bee9ec375c3a0f9ef8ed7456a51dcd | 76940 | rolim de moura | RO | 1 | 6c7a0a349ad11817745e3ad58abd5c79 | 48162d548f5b1b11b9d29d1e01f75a61 | 2017-01-30 11:09:00 | 183.29 | 25.77 | seguros_e_servicos | 55.0 | 506.0 | 1.0 | 1225.0 | 27.0 | 35.0 | 15.0 | security_and_services | 4 | Envio muito rápido. Recomendo. |
| 115608 | bede3503afed051733eeb4a84d1adcc5 | 919570a26efbd068d6a0f66d5c5072a3 | delivered | 1 | boleto | 1 | 115.45 | 141e824b8e0df709e3fcf6d982225a8e | 71940 | brasilia | DF | 1 | 8db75af9aed3315374db44d7860e25da | 4e922959ae960d389249c378d1c939f5 | 2017-09-26 04:05:52 | 100.00 | 15.45 | seguros_e_servicos | 48.0 | 461.0 | 4.0 | 400.0 | 26.0 | 22.0 | 11.0 | security_and_services | 1 | boa tarde produto enviado errado, terei que me deslocar aos correios pois moro em um condomínio tive receber, e ainda irei esperar chegar para so depois eu receber o produto correto, paguei via boleto |
Most frequently occurring
| order_id | customer_id | order_status | payment_sequential | payment_type | payment_installments | payment_value | customer_unique_id | customer_zip_code_prefix | customer_city | customer_state | order_item_id | product_id | seller_id | shipping_limit_date | price | freight_value | product_category_name | product_name_lenght | product_description_lenght | product_photos_qty | product_weight_g | product_length_cm | product_height_cm | product_width_cm | product_category_name_english | review_score | review_comment_message | # duplicates | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 245 | df56136b8031ecd28e200bb18e6ddb2e | b7770073b02ed1d626a027ce86a4ff82 | delivered | 1 | boleto | 1 | 204.72 | 2e43e031f10de28e557c35ef668f9396 | 92410 | canoas | RS | 1 | f28cbd414cd06f1ae84065c8dd8be834 | 4da0e408c99d2fdc2126dc9fce518060 | 2017-01-30 13:15:41 | 23.90 | 2.53 | esporte_lazer | 60.0 | 806.0 | 1.0 | 700.0 | 20.0 | 12.0 | 16.0 | sports_leisure | 5 | No reviews | 3 |
| 246 | df56136b8031ecd28e200bb18e6ddb2e | b7770073b02ed1d626a027ce86a4ff82 | delivered | 1 | boleto | 1 | 204.72 | 2e43e031f10de28e557c35ef668f9396 | 92410 | canoas | RS | 2 | 50aa8f292a9510d5542f2a078903a2a7 | 834f8533b2ecb6598dd004ff3de7203a | 2017-01-30 13:15:41 | 63.92 | 15.82 | esporte_lazer | 49.0 | 1141.0 | 2.0 | 400.0 | 19.0 | 11.0 | 37.0 | sports_leisure | 5 | No reviews | 3 |
| 247 | df56136b8031ecd28e200bb18e6ddb2e | b7770073b02ed1d626a027ce86a4ff82 | delivered | 1 | boleto | 1 | 204.72 | 2e43e031f10de28e557c35ef668f9396 | 92410 | canoas | RS | 3 | 3025303c80b01a0926fda2841cc31b4a | 4da0e408c99d2fdc2126dc9fce518060 | 2017-01-30 13:15:41 | 66.90 | 31.65 | esporte_lazer | 56.0 | 222.0 | 2.0 | 2100.0 | 40.0 | 25.0 | 28.0 | sports_leisure | 5 | No reviews | 3 |
| 0 | 0176a6846bcb3b0d3aa3116a9a768597 | aaad67429ea7d339bdf5f71ae3ef74f6 | delivered | 1 | boleto | 1 | 53.68 | 13613cae6e3bfea8327a916246c96cc9 | 5108 | sao paulo | SP | 1 | 19421075ae0b585f2dc13ff149e2119d | 4c2b230173bb36f9b240f2b8ac11786e | 2018-01-03 04:32:07 | 45.90 | 7.78 | esporte_lazer | 32.0 | 1797.0 | 1.0 | 150.0 | 16.0 | 16.0 | 11.0 | sports_leisure | 5 | No reviews | 2 |
| 1 | 03515a836bb855b03f7df9dee520a8fc | 153e6d880db3cac30ecfeb13e0047841 | delivered | 1 | credit_card | 10 | 106.38 | 159306b86e782097be9a4e29e3d294d3 | 95540 | palmares do sul | RS | 1 | 2b4609f8948be18874494203496bc318 | cc419e0650a3c5ba77189a1882b7556a | 2018-01-29 13:36:01 | 89.99 | 16.39 | beleza_saude | 59.0 | 492.0 | 3.0 | 250.0 | 22.0 | 10.0 | 18.0 | health_beauty | 5 | No reviews | 2 |
| 2 | 05452881e2846549b81d39249bb66ad7 | 1ff911e9682875f08a0f44bad0807455 | delivered | 1 | credit_card | 8 | 224.60 | 744fb2d41ededa16d3f703b7065b234c | 2215 | sao paulo | SP | 1 | 283dc451ad3918badb976d56ff887289 | da8622b14eb17ae2831f4ac5b9dab84a | 2018-02-11 22:35:33 | 99.90 | 12.40 | cama_mesa_banho | 58.0 | 188.0 | 1.0 | 1650.0 | 44.0 | 2.0 | 35.0 | bed_bath_table | 5 | No reviews | 2 |
| 3 | 05452881e2846549b81d39249bb66ad7 | 1ff911e9682875f08a0f44bad0807455 | delivered | 1 | credit_card | 8 | 224.60 | 744fb2d41ededa16d3f703b7065b234c | 2215 | sao paulo | SP | 2 | 283dc451ad3918badb976d56ff887289 | da8622b14eb17ae2831f4ac5b9dab84a | 2018-02-11 22:35:33 | 99.90 | 12.40 | cama_mesa_banho | 58.0 | 188.0 | 1.0 | 1650.0 | 44.0 | 2.0 | 35.0 | bed_bath_table | 5 | No reviews | 2 |
| 4 | 056bfadd41b8600ad5ecfef2ac132188 | 91faeb032f47277f654a8202eaa9fed6 | delivered | 1 | credit_card | 3 | 35.01 | 2106e7aa97e2b0bb0193c9f2478d85e0 | 9895 | sao bernardo do campo | SP | 1 | 2bb67f2cd3ff60400e0bad33aee72d2a | daeb5653dd96c1b11860f72209795012 | 2017-11-30 11:15:31 | 19.90 | 15.11 | brinquedos | 49.0 | 872.0 | 1.0 | 550.0 | 40.0 | 10.0 | 30.0 | toys | 4 | No reviews | 2 |
| 5 | 06b2c7035561ef12b16045ef4bf459e2 | 8bb9547aec97f493e91a078f66fa7ac5 | delivered | 1 | credit_card | 6 | 68.02 | 630331e73a79ae9a2ba821bd326ea298 | 88850 | forquilhinha | SC | 1 | f7a17d2c51d9df89a4f1711c4ac17f33 | f8db351d8c4c4c22c6835c19a46f01b0 | 2017-07-11 17:28:03 | 52.90 | 15.12 | utilidades_domesticas | 56.0 | 1245.0 | 5.0 | 350.0 | 22.0 | 8.0 | 19.0 | housewares | 5 | No reviews | 2 |
| 6 | 0715dfcf2383aa72c181d8b47f6cb589 | 0ea00ae539e6a29390c4e1d0841352e4 | delivered | 1 | credit_card | 3 | 97.02 | b0ac5b393b78a6e8185fd3acb154748d | 99150 | marau | RS | 1 | 9b4d597238711e4dfc04d98bb2e5ed17 | 7681ef142fd2c19048da7430856b5588 | 2018-02-20 10:55:31 | 76.00 | 21.02 | industria_comercio_e_negocios | 58.0 | 1553.0 | 4.0 | 5200.0 | 38.0 | 30.0 | 25.0 | industry_commerce_and_business | 5 | No reviews | 2 |